Re: postgres standby won't start - Mailing list pgsql-general

Yes it is and Yes I do have the recovery file.
Here is the scenario. It looks like the logs are not getting shipped over to the standby. After I dragged the WAL files
fromPrimary to Standby and restarted, I see some successful recovery messages with the file names mentioned. Right now
thestandby is now functional as READ ONLY. 
One question would be why logs are not getting shipped to standby even though my log say connection to primary
successful.

Another question, if I have to make it a standalone DB instead of standby, now that I have the required data in place,
whatchanges I need to do in Primary as well as here. 

Thanks a lot for your continuous response.

P.S. I did use pg_basebackup and moved the tar file to standby and overwrote (after cleaning up data folder) the data
folderand then started the db 



Thanks
Kumar Ramalingam
X6015288


-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Thursday, October 08, 2015 9:31 AM
To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres standby won't start

On 10/07/2015 10:01 PM, Ramalingam, Sankarakumar wrote:
> Hi Adrian,
> After a few attempts I used the following (without method=stream as it
> is not working on 9.1) and restored the DB on standby site
> successfully. The log says it is connecting to primary streaming
> replication successfully connected to primary
>
> but still complains about some log files.
>
> 2015-10-08 00:47:37 EDT LOG:  streaming replication successfully
> connected to primary
> 2015-10-08 00:53:53 EDT LOG:  received smart shutdown request
> 2015-10-08 00:53:53 EDT FATAL:  terminating walreceiver process due to
> administrator command
> 2015-10-08 00:53:53 EDT LOG:  shutting down
> 2015-10-08 00:53:53 EDT LOG:  database system is shut down
> 2015-10-08 00:54:04 EDT LOG:  database system was shut down in
> recovery at 2015-10-08 00:53:53 EDT
> cp: cannot stat `/db_logs/pgsql/archive/0000001A.history': No such
> file or directory
> 2015-10-08 00:54:04 EDT LOG:  entering standby mode
> cp: cannot stat `/db_logs/pgsql/archive/0000001A00000845000000C9': No
> such file or directory
> 2015-10-08 00:54:04 EDT LOG:  redo starts at 845/C9000020
> 2015-10-08 00:54:04 EDT LOG:  consistent recovery state reached at
> 845/CA000000
> 2015-10-08 00:54:04 EDT LOG:  database system is ready to accept read
> only connections
> cp: cannot stat `/db_logs/pgsql/archive/0000001A00000845000000CA': No
> such file or directory
> 2015-10-08 00:54:04 EDT LOG:  streaming replication successfully
> connected to primary
> 2015-10-08 00:56:21 EDT LOG:  connection received: host=[local]
> 2015-10-08 00:56:21 EDT LOG:  connection authorized: user=postgres
> database=clients

So what is '/db_logs/pgsql/archive/'?

For the moment I going to guess it is a WAL archive location. If so, do you have a recovery.conf on the standby and an
restore_commandin it that points to that location? 

>
>
> Thanks
> Kumar Ramalingam
> X6015288
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
> Sent: Wednesday, October 07, 2015 8:06 PM
> To: Ramalingam, Sankarakumar; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] postgres standby won't start
>
> On 10/07/2015 01:30 PM, Ramalingam, Sankarakumar wrote:
>> Hello Adrian,
>> Can I use this command so that all the data is streamed directly to the target. Target is pretty much unusable now.
ShouldI get rid of all items under my $PGDATA and leave the empty before doing the following? 
>>
>> pg_basebackup -h <my target hostname>  -D <my target host directory>
>> -P -U replication --xlog-method=stream
>
> Just to be sure the target is the standby server, correct?
>
> If so you do not want this:
>
> -h <my target hostname>
>
> -h is for the server you are taking the backup of, or to put it another way the flow is from -h to -D.
>
> If you are running pg_basebackup on the same machine as the primary then:
>
> pg_basebackup  -D <my target host directory>  -P -U replication --xlog-method=stream
>
> This assumes there is only one instance of Postgres running on that machine and it is running on port 5432. If not
thenyou will need to specify -p <correct_port> 
>
> pg_basebackup is a client program, so like other such programs you have to tell it what database(cluster) to connect
tousing the normal switches, see below. Actually pg_basebackup does not connect to a specific database but to the
databasecluster, so any database name you supply will be ignored. 
>
> http://www.postgresql.org/docs/9.4/interactive/app-pgbasebackup.html
>
> "The following command-line options control the database connection parameters."
>
>>
>>
>>
>> Thanks
>> Kumar Ramalingam
>> X6015288
>>
>>
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
> The information contained in this e-mail and in any attachments is intended only for the person or entity to which it
isaddressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other
useof, or taking of any action in reliance upon, this information by persons or entities other than the intended
recipientis prohibited. This message has been scanned for known computer viruses. 
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com
The information contained in this e-mail and in any attachments is intended only for the person or entity to which it
isaddressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other
useof, or taking of any action in reliance upon, this information by persons or entities other than the intended
recipientis prohibited. This message has been scanned for known computer viruses.