OK, here is more cleaner cut and paste from my notebook:
[EMAIL PROTECTED]:~/test$ initdb -D ./t1 [EMAIL PROTECTED]:~/test$ pg_ctl -D ./t1 start postmaster starting [EMAIL PROTECTED]:~/test$ LOG: database system was shut down at 2005-03-23 01:09:34 MSK LOG: checkpoint record is at 0/A2C844 LOG: redo record is at 0/A2C844; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 544; next OID: 17230 LOG: database system is ready
[EMAIL PROTECTED]:~/test$ createdb test CREATE DATABASE [EMAIL PROTECTED]:~/test$ psql test -c "create table a (f integer);" CREATE TABLE
$i); commit;"; done
COMMIT
COMMIT
COMMIT
COMMIT
COMMIT
COMMIT
COMMIT
COMMIT
COMMIT
COMMIT
[EMAIL PROTECTED]:~/test$ cp -a ./t1 ./t2
[EMAIL PROTECTED]:~/test$ rm ./t2/postmaster.pid rm: remove regular file ./t2/postmaster.pid'? y
[EMAIL PROTECTED]:~/test$ pg_ctl -D ./t1 stop
LOG: received smart shutdown request
LOG: shutting down
waiting for postmaster to shut down....LOG: database system is shut down
done
postmaster stopped
[EMAIL PROTECTED]:~/test$ LOG: database system was interrupted at 2005-03-23 01:10:06 MSK
LOG: checkpoint record is at 0/A2C844
LOG: redo record is at 0/A2C844; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 544; next OID: 17230
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 0/A2C880
LOG: record with zero length at 0/A4FD38
LOG: redo done at 0/A4FD10
LOG: database system is ready
[EMAIL PROTECTED]:~/test$ psql test -c "select count(*) from a;"
count -------
10
(1 row)
[EMAIL PROTECTED]:~/test$ pg_ctl -D ./t2 stop waiting for postmaster to shut down....LOG: received smart shutdown request LOG: shutting down LOG: database system is shut down done postmaster stopped
[EMAIL PROTECTED]:~/test$ pg_ctl -D ./t1 start postmaster starting [EMAIL PROTECTED]:~/test$ LOG: database system was shut down at 2005-03-23 01:11:40 MSK LOG: checkpoint record is at 0/A4FD38 LOG: redo record is at 0/A4FD38; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 568; next OID: 17243 LOG: database system is ready
[EMAIL PROTECTED]:~/test$ psql test -c "select count(*) from a;" ERROR: relation "a" does not exist ERROR: relation "a" does not exist
So, where is my table 'a' ?
Oleg
On Wed, 23 Mar 2005, Oleg Bartunov wrote:
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
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 7: don't forget to increase your free space map settings
