From: Rossi, Maria <maria.rossi@us.pgds.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Relocated Postgres
Date: Wed, 11 Mar 2015 01:02:53 +0000
Message-ID: <33A4D5087BF0D44DA69C5EEF666BC1D742507AD2@usprmbp01c> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
HI,
I relocated an postgres instance. The pg_data, pg_tranlog, pg_hba.conf, etc were copied to new directories. 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
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: maria.rossi@us.pgds.com
Subject: Re: Relocated Postgres
In-Reply-To: <33A4D5087BF0D44DA69C5EEF666BC1D742507AD2@usprmbp01c>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox