odd problem !

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

Responses

Browse pgsql-hackers by date

  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