[GENERAL] how can we resolving locking state ....

hi.. we test locking PostgreSQL 8.4.4 on x86_64. 1> session 1 ### $ psql mydb drop table citytest; CREATE TABLE citytest ( i_id integer , city varchar(80) ) ; ALTER TABLE citytest ADD CONSTRAINT citytest_pkey PRIMARY KEY (i_id); insert into citytest values (1,'aaa'); i

[GENERAL] Could you teach me, How can we speci fy password when using psql....

hi.. when using oracle sqlplus.. we can specify password. $ sqlplus system/manager Could you teach me, How can we specify password when using psql $ psql -p 5432 -h rac2 -d mydb -U hsnoh Password for user hsnoh: Thanks.. noh019님의 블로그 안녕하세요.

[GENERAL] we test pgpool-II with Shared Sto rage (Active-Standby)..

hi.. 1 # we test pgpool-II with Shared Storage (Active-Standby).. pgpool-II test(192.168.2.99) Active rac1 (192.168.2.61) Stadnby rac2 (192.168.2.71) 2 # we have question... 1>