[GENERAL] Postgres upgrade from 9.4.9 to 9.6 using pg_upgrade error

9.6, which is not compatible with this version 9.4.9. stopped waiting pg_ctl: could not start server Examine the log output. Is it possible to upgrade Postgres 9.4.9 to 9.6 with pg_upgrade option or I need to do it through pg_dump only? Any help would be appreciated. Thanks, Ashish Chauhan

[GENERAL] pg_upgrade_server.log file location

Please shutdown that postmaster and try again. Failure, exiting Thanks, Ashish Chauhan

[GENERAL] pgpoolAdmin - pgmgt.conf.php write denied error

SION - assumed '_PGPOOL2_VERSION' in /var/www/html/pgpoolAdmin-3.5.3/bootstrap.php on line 33, referer: http://xx.xx.xx.xx/pgpoolAdmin-3.5.3/install/checkDirectory.php"; Thanks, Ashish Chauhan

Re: [GENERAL] Setup pgpool-II with streaming replication

: Ashish Chauhan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Setup pgpool-II with streaming replication I gone through below articles but some or other way require DB server restart which is not possible in our case. Could you please provide some documentation or steps how to achive

[GENERAL] Setup pgpool-II with streaming replication

without any downtime? http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/ http://www.wirabumisoftware.com/en/openbravo-developer-guide/postgresqldevtutorial/25-pgsqlid/82-install-pgpool2 Thanks, Ashish Chauhan

[GENERAL] Script to check replication

behind. SELECT pg_last_xlog_receive_location() receive, pg_last_xlog_replay_location() replay, now() - pg_last_xact_replay_timestamp() AS replication_delay, (extract(epoch FROM now()) - extract(epoch FROM pg_last_xact_replay_timestamp()))::int lag Thanks for your help! Thanks, Ashish Chauhan

Re: [GENERAL] Live steraming replication setup issue!

:01.612415 | -2 Thanks, Ashish From: Venkata Balaji N [mailto:nag1...@gmail.com] Sent: Sunday, February 21, 2016 2:14 AM, 2:14 To: Ashish Chauhan Cc: Andreas Kretschmer; pgsql-general@postgresql.org Subject: Re: [GENERAL] Live steraming replication setup issue! On Fri, Feb 19, 2016 at 6:24 PM

Re: [GENERAL] Live steraming replication setup issue!

server will poll the trigger file path periodically and start as a # primary server when it's found. # trigger_file = '/data/main/primary.trigger' Thanks, Ashish -Original Message- From: Andreas Kretschmer [mailto:andr...@a-kretschmer.de] Sent: Thursday, February 18, 201

Re: [GENERAL] Live steraming replication setup issue!

? archive_mode = on and archive_command = some command? Biggest issue is, replication running between master and slave and I need to build DR from slave server. Thanks, Ashish From: Venkata Balaji N [mailto:nag1...@gmail.com] Sent: Thursday, February 18, 2016 3:45 PM, 15:45 To: Ashish Chauhan Cc

[GENERAL] Live steraming replication setup issue!

Hi, Currently we have master -> slave -> DR hot standby streaming replication in current prod environment. Between master and slave server replication running fine. Between slave and DR server replication is broken and I am trying to fix it. For DR server, slave server is master server. Issue: