Re: Relocated Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux