Hello. Yes Sir. Below the procedure:
root@be6000-cupm ~]#
[root@be6000-cupm ~]# cd /opt/
cupm/ lost+found/ system/
[root@be6000-cupm ~]# cd /opt/
cupm/ lost+found/ system/
[root@be6000-cupm ~]# cd /mnt/
data/ hgfs/
[root@be6000-cupm ~]# cd /mnt/data/
cupm/ lost+found/
[root@be6000-cupm ~]# cd /mnt/data/cupm/
envvar.sh jboss/ logs/ postgres/ voiceProvInstall.sh
ErrorCode.txt jvm/ pmdb.sh sep/ voiceProvReInitialize.sh
httpd/ license/ pmservers.sh velocity.log voiceProvUninstall.sh
[root@be6000-cupm ~]# cd /mnt/data/cupm/postgres/9.0/bin/
clusterdb droplang pg_config pg_standby postmaster
createdb dropuser pg_controldata pg_upgrade psql
createlang ecpg pg_ctl pltcl_delmod psql.bin
createuser initdb pg_dump pltcl_listmod reindexdb
CUPM-implicit-functions.sql oid2name pg_dumpall pltcl_loadmod vacuumdb
CUPM-restore.sh pg_archivecleanup pg_resetxlog postgres vacuumlo
dropdb pgbench pg_restore postgres-9.0-openscg
[root@be6000-cupm ~]# cd /mnt/data/cupm/postgres/9.0/bin/
[root@be6000-cupm bin]# ./psql -Upmadmin -d cupm
psql.bin (9.0.5)
Type "help" for help.
cupm=# select failedloginnum from users where id="pmadmin" ;
ERROR: column "pmadmin" does not exist
LINE 1: select failedloginnum from users where id="pmadmin" ;
^
cupm=# select failedloginnum from users where id= "pmadmin" ;
ERROR: column "pmadmin" does not exist
LINE 1: select failedloginnum from users where id= "pmadmin" ;
^
cupm=# select failedloginnum from users where id= "admin" ;
ERROR: column "admin" does not exist
LINE 1: select failedloginnum from users where id= "admin" ;
^
cupm=# select failedloginnum from users where id= 'pmadmin' ;
failedloginnum
----------------
99
(1 row)
cupm=# update users set failedloginnum=0 where id= 'pmadmin'
cupm-# select failedloginnum from users where id= 'pmadmin' ;
ERROR: syntax error at or near "select"
LINE 2: select failedloginnum from users where id= 'pmadmin' ;
^
cupm=# select failedloginnum from users where id= 'pmadmin' ; failedloginnum
----------------
99
(1 row)
cupm=# update users set failedloginnum='0' where id= 'pmadmin' ;
UPDATE 1
cupm=# select failedloginnum from users where id= 'pmadmin' ;
failedloginnum
----------------
0
(1 row)
cupm=# select failedloginnum from users where id= 'admin' ;
failedloginnum
----------------
99
(1 row)
cupm=# update users set failedloginnum='0' where id= 'admin' ;
UPDATE 1
cupm=# select failedloginnum from users where id= 'admin' ;
failedloginnum
----------------
0
(1 row)
