Relocated Postgres

From: "Rossi, Maria" <maria(dot)rossi(at)us(dot)pgds(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Relocated Postgres
Date: 2015-03-11 01:02:53
Message-ID: 33A4D5087BF0D44DA69C5EEF666BC1D742507AD2@usprmbp01c
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message CS DBA 2015-03-11 16:15:44 Downgrade from 9.2.10 to 9.2.6
Previous Message Guillaume Lelarge 2015-03-10 12:52:57 Re: pgstat wait timeout encountered