El mié, 11-03-2015 a las 01:02 +0000, Rossi, Maria escribió: > HI, > Hi, > > > I relocated an postgres instance. The pg_data, pg_tranlog, > pg_hba.conf, etc were copied to new directories. did you stop the instance, before start the copy ? > Then, I updated the postgresql.conf accordingly. Postgres started > ok, and I can connect. However when I stopped it, the following msg > appeared at the errorlog: > > > > cp: overwrite > `/dba/psg/gs07/pg_tranlog/pg_archlog/00000001000000000000004C'? < > 2015-03-10 20:50:38 EDT >LOG: database system is shut down > Could you share with us archive_command and archive_mode of postgresql.conf ? It seems than you are using "cp -i" in your archive_command, doesn't it ? > > > Postgres proceeded to shutdown. > > > > ‘ls’ showed that the file still have the old timestamp, which is the > timestamp when I copied it over: > > > > ls -ltr /dba/psg/gs07/pg_tranlog/pg_archlog/00000001000000000000004B > > -rw------- 1 gs07 dbagroup 16777216 Mar 10 > 12:07 /dba/psg/gs07/pg_tranlog/pg_archlog/0000000100 > > > > I did not have any transctions, though between the start-up and > shutdown. I would have expected the timestamp of the logfile to have > been changed. > > Looks like it was waiting for a response to ‘cp’. > > > > I am concerned that if there were any transactions, I would have lost > it. > > Pls advice. > > > > Thanks. > > > > Maria > > > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
