agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedNeed documentation for PostgreSQL Replication support.
6+ messages / 3 participants
[nested] [flat]
* Need documentation for PostgreSQL Replication support.
@ 2016-02-10 06:36 Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
2016-02-10 06:52 ` Re: Need documentation for PostgreSQL Replication support. Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Venkatesan, Sekhar @ 2016-02-10 06:36 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; Mike Sofen <msofen@runbox.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql; Mallela, Anil <anil.mallela@emc.com>
Hi Folks,
I need official documentation/links where I find information on PostgreSQL Replication support. Can someone shed some light on this?
Thanks,
Sekhar
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Need documentation for PostgreSQL Replication support.
2016-02-10 06:36 Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
@ 2016-02-10 06:52 ` Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 0 replies; 6+ messages in thread
From: Thomas Kellerer @ 2016-02-10 06:52 UTC (permalink / raw)
To: pgsql-sql
Venkatesan, Sekhar schrieb am 10.02.2016 um 07:36:
> I need official documentation/links where I find information on PostgreSQL Replication support.
> Can someone shed some light on this?
Do you mean something else than the official manual?
http://www.postgresql.org/docs/current/static/high-availability.html
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Need documentation for PostgreSQL Replication support.
@ 2016-02-29 03:58 Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
2016-02-29 07:29 ` Re: Need documentation for PostgreSQL Replication support. Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Venkatesan, Sekhar @ 2016-02-29 03:58 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; Mike Sofen <msofen@runbox.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql; Mallela, Anil <anil.mallela@emc.com>; pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
Hi Folks,
Any help regarding the below topic? I want to certify PostgreSQL replication functionality with my application and I need assistance on this?
Thanks,
Sekhar
-----Original Message-----
From: Venkatesan, Sekhar
Sent: Wednesday, February 10, 2016 12:07 PM
To: 'Adrian Klaver'; 'David G. Johnston'; 'Mike Sofen'
Cc: 'Tom Lane'; 'pgsql-sql@postgresql.org'; Mallela, Anil
Subject: Need documentation for PostgreSQL Replication support.
Hi Folks,
I need official documentation/links where I find information on PostgreSQL Replication support. Can someone shed some light on this?
Thanks,
Sekhar
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Need documentation for PostgreSQL Replication support.
2016-02-29 03:58 Re: Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
@ 2016-02-29 07:29 ` Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 0 replies; 6+ messages in thread
From: Thomas Kellerer @ 2016-02-29 07:29 UTC (permalink / raw)
To: pgsql-sql; +Cc: pgsql-odbc@postgresql.org
Venkatesan, Sekhar schrieb am 29.02.2016 um 04:58:
> Hi Folks,
>
> Any help regarding the below topic? I want to certify PostgreSQL replication functionality with my application and I need assistance on this?
>
> Thanks,
> Sekhar
>
> -----Original Message-----
> From: Venkatesan, Sekhar
> Sent: Wednesday, February 10, 2016 12:07 PM
> To: 'Adrian Klaver'; 'David G. Johnston'; 'Mike Sofen'
> Cc: 'Tom Lane'; 'pgsql-sql@postgresql.org'; Mallela, Anil
> Subject: Need documentation for PostgreSQL Replication support.
>
> Hi Folks,
>
> I need official documentation/links where I find information on PostgreSQL Replication support. Can someone shed some light on this?
The manual is a good start:
http://www.postgresql.org/docs/current/static/high-availability.html
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Need documentation for PostgreSQL Replication support.
@ 2016-02-29 04:01 Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
2016-03-01 03:48 ` Re: Need documentation for PostgreSQL Replication support. Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com>
0 siblings, 1 reply; 6+ messages in thread
From: Venkatesan, Sekhar @ 2016-02-29 04:01 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; Mike Sofen <msofen@runbox.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql; Mallela, Anil <anil.mallela@emc.com>; pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
We have tried the following steps for PostgreSQL streaming replication (attached mail) and ran into issues. Can anyone indicate what is wrong with the configuration?
Thanks,
Sekhar
-----Original Message-----
From: Venkatesan, Sekhar
Sent: Monday, February 29, 2016 9:28 AM
To: 'Adrian Klaver'; 'David G. Johnston'; 'Mike Sofen'
Cc: 'Tom Lane'; 'pgsql-sql@postgresql.org'; Mallela, Anil; 'pgsql-odbc@postgresql.org'
Subject: RE: Need documentation for PostgreSQL Replication support.
Hi Folks,
Any help regarding the below topic? I want to certify PostgreSQL replication functionality with my application and I need assistance on this?
Thanks,
Sekhar
-----Original Message-----
From: Venkatesan, Sekhar
Sent: Wednesday, February 10, 2016 12:07 PM
To: 'Adrian Klaver'; 'David G. Johnston'; 'Mike Sofen'
Cc: 'Tom Lane'; 'pgsql-sql@postgresql.org'; Mallela, Anil
Subject: Need documentation for PostgreSQL Replication support.
Hi Folks,
I need official documentation/links where I find information on PostgreSQL Replication support. Can someone shed some light on this?
Thanks,
Sekhar
Hi Raghavendra/sekhar,
I have tried base postgres streaming replication with Content server. Database/tables/schema are replicated from master to slave properly but I am facing odbc connectivity issue from master to slave. Due to that I am unable to stop master postgres service and test the CS functionality when master is down.
I have added below entries in pg_hbf.conf of master vm
host all all 10.31.159.199/32 md5(master)
host all all 10.31.159.204/32 md5(slave)
and also recreated postmaster.pid file Even then I have seen below issue during odbc connectivity from master to slave:
psql: FATAL: no pg_hba.conf entry for host "10.31.159.199", user "postgres", database "postgres", SSL off
Can you please suggest me is there any other approach I can follow to resolve above issue.
please find the attached replication configuration steps with environment details.
Note : Not seeing issue with slave vm for odbce connectivity of master
Thanks,
Anil.
Master postgres server:10.31.159.199(Administrator/Password@123)
Prerequisite :create a archive folder and share with full permissions
PostgreSQL.conf(location:C:\Program Files\PostgreSQL\9.4\data)
wal_level = hot_standby
archive_mode = on
archive_command = archive_command = 'copy %p \\\\10.31.159.199\\archive
%f'
max_wal_senders = 1
wal_keep_segments = 10
pb_hbf.conf
Add...below entry
host replication replication 10.31.159.204/32 trust
Slave:
PostgreSQL.conf:
hot_standby = on
Create recovery.conf(location:C:\Program Files\PostgreSQL\9.4\data) and add below entries
restore_command = 'copy \\\\10.31.159.199\\archive %f %p'
standby_mode = 'on'
primary_conninfo = 'host=10.31.159.199 port=5432 user=postgres password=password'
pb_hbf.conf
Add...below entry
host replication postgres 10.31.159.199/32 md5
Go to master and create a backup
login to postgres and execute the below command
SELECT pg_start_backup('base');
Copy postgres data folder excluding some configuration files from master to slave
stop the postgres backup
SELECT pg_stop_backup();
try to restart the slave postgresservice
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Attachments:
[text/plain] postgres.txt (1.1K, ../../F84DE43FDACD4C45AA84E2DA016FAE2F1C66A4A7@MX105CL01.corp.emc.com/4-postgres.txt)
download | inline:
Master postgres server:10.31.159.199(Administrator/Password@123)
Prerequisite :create a archive folder and share with full permissions
PostgreSQL.conf(location:C:\Program Files\PostgreSQL\9.4\data)
wal_level = hot_standby
archive_mode = on
archive_command = archive_command = 'copy %p \\\\10.31.159.199\\archive
%f'
max_wal_senders = 1
wal_keep_segments = 10
pb_hbf.conf
Add...below entry
host replication replication 10.31.159.204/32 trust
Slave:
PostgreSQL.conf:
hot_standby = on
Create recovery.conf(location:C:\Program Files\PostgreSQL\9.4\data) and add below entries
restore_command = 'copy \\\\10.31.159.199\\archive %f %p'
standby_mode = 'on'
primary_conninfo = 'host=10.31.159.199 port=5432 user=postgres password=password'
pb_hbf.conf
Add...below entry
host replication postgres 10.31.159.199/32 md5
Go to master and create a backup
login to postgres and execute the below command
SELECT pg_start_backup('base');
Copy postgres data folder excluding some configuration files from master to slave
stop the postgres backup
SELECT pg_stop_backup();
try to restart the slave postgresservice
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Need documentation for PostgreSQL Replication support.
2016-02-29 04:01 Re: Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
@ 2016-03-01 03:48 ` Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com>
0 siblings, 0 replies; 6+ messages in thread
From: Tsunakawa, Takayuki @ 2016-03-01 03:48 UTC (permalink / raw)
To: Venkatesan, Sekhar <sekhar.venkatesan@emc.com>; Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; Mike Sofen <msofen@runbox.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql; Mallela, Anil <anil.mallela@emc.com>; pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
Hello, Sekhar,
Did you see the manual here?
http://www.postgresql.org/docs/current/static/high-availability.html
I'm afraid the trouble has nothing to do with ODBC... If so, pgsql-general@postgresql.org is the right place.
Regards
Takayuki Tsunakawa
> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Venkatesan, Sekhar
> Sent: Monday, February 29, 2016 1:01 PM
> To: Adrian Klaver; David G. Johnston; Mike Sofen
> Cc: Tom Lane; pgsql-sql@postgresql.org; Mallela, Anil;
> pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Need documentation for PostgreSQL Replication support.
>
> We have tried the following steps for PostgreSQL streaming replication
> (attached mail) and ran into issues. Can anyone indicate what is wrong with
> the configuration?
>
> Thanks,
> Sekhar
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2016-03-01 03:48 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-02-10 06:36 Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
2016-02-10 06:52 ` Thomas Kellerer <spam_eater@gmx.net>
2016-02-29 03:58 Re: Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
2016-02-29 07:29 ` Thomas Kellerer <spam_eater@gmx.net>
2016-02-29 04:01 Re: Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
2016-03-01 03:48 ` Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox