From: jaime soler <jaime.soler@gmail.com>
To: Rossi, Maria <maria.rossi@us.pgds.com>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Relocated Postgres
Date: Wed, 11 Mar 2015 17:35:12 +0100
Message-ID: <1426091712.6353.4.camel@gmail.com> (raw)
In-Reply-To: <33A4D5087BF0D44DA69C5EEF666BC1D742507AD2@usprmbp01c>
References: <33A4D5087BF0D44DA69C5EEF666BC1D742507AD2@usprmbp01c>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: jaime.soler@gmail.com, maria.rossi@us.pgds.com
Subject: Re: Relocated Postgres
In-Reply-To: <1426091712.6353.4.camel@gmail.com>
* 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