From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | odd problem ! |
Date: | 2005-03-22 21:40:35 |
Message-ID: | Pine.GSO.4.62.0503230034170.5508@ra.sai.msu.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)zen:~/test$ psql -l
List of databases
Name | Owner | Encoding
-----------+----------+----------
template0 | postgres | KOI8
template1 | postgres | KOI8
test | postgres | KOI8
(3 rows)
11.
pg(at)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2005-03-22 21:51:27 | Re: [HACKERS] what to do with backend flowchart |
Previous Message | Tom Lane | 2005-03-22 21:17:28 | Re: Proposal: OUT parameters for plpgsql |