Hi there,
below is the problem I just bitten when play with toy db. I did:
1.initdb -D ./t1 2. pg_ctl -D ./t1 start 3. createdb test 4. psql test -c "create table a (f integer);" 5. run script which populates table a in background perl bgupdate.pl & 6. cp -a ./t1 ./t2 6. pg_ctl -D ./t1 stop it's waiting for bgupdate.pl, so I killed script 7. pg_ct -D ./t2 start see, that everything is fine. 8. pg_ctl -D ./t2 stop 9. pg_ctl -D ./t1 start 10.
[EMAIL PROTECTED]:~/test$ psql -l
List of databases
Name | Owner | Encoding -----------+----------+----------
template0 | postgres | KOI8
template1 | postgres | KOI8
test | postgres | KOI8
(3 rows)
11. [EMAIL PROTECTED]:~/test$ psql test FATAL: database "test" does not exist psql: FATAL: database "test" does not exist
So, how it's possible ?
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
