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.
pg@zen:~/test$ psql -l List of databases Name | Owner | Encoding
-----------+----------+---------- template0 | postgres | KOI8 template1 | postgres | KOI8 test | postgres | KOI8
(3 rows)
11.
pg@zen:~/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