[pgadmin-hackers] Hot stand by streaming replication in postgresql 9.2

[gurunadh.venk...@gmail.com]

Hi i am new to PostgreSQL and one of my colleague gave me a task to do Hot
stand by streaming replication in 9.2.


I am having some confusion how to set the "archive_command" and
restore_command parameters

master  postgresql server installation was loacted   at
/opt/PostgreSQL/9.2(IN Redhat Linux (6.x) 

 slave server installation was configured at /var/lib/postgres/

and also help me how to set the restore_command in the slave
side(recovery.conf file).

master details 
  
IP:10.0.0.100

In postgresql.conf file:

listen_addresses = '*'
wal_level = hot_standby
max_wal_senders = 1
wal_keep_segments = 5
archive_mode = on
archive_command = ?(Dont no how to setup the parameter)

In pg_hba.conf file:

host  replication   repuser   10.0.0.200  trust

Slave Details:

 postgresql.conf

hot_standby = on

Created recovery.conf, with the following lines:

restore_command = (Help me how to set this parameter)
standby_mode = 'on'
primary_conninfo = 'host=10.0.0.100 port=  user=repuser password=rep 

 select pg_start_backup('base backup');

here i have to copy all the data dir to slave 

rsync -av --exclude pg_xlog --exclude postgresql.conf data/*
10.0.0.200:/var/lib/postgresql/data/ 

select pg_stop_backup();

My Lead said when you query the below three SQL statements you have to get
same O/P then you have done every thing fine.

For Example:

In master 

SELECT pg_current_xlog_location();

pg_current_xlog_location
--
 0/1C80
(1 row).

Then on the standby, you can run:
# SELECT pg_last_xlog_receive_location();
pg_last_xlog_receive_location
--
 0/1C80
(1 row)
# SELECT pg_last_xlog_replay_location();
pg_last_xlog_replay_location
--
 0/1C80
(1 row)

Sorry For my english.

Thanks in advance
 venkat



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Hot-stand-by-streaming-replication-in-postgresql-9-2-tp5804542.html
Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Re: [BUGS] BUG #10250: pgAdmin III 1.16.1 stores unescaped plaintext password

[Dhiraj Chawla]

Sure Dave. I will review the patch and update accordingly.

regards,

*Dhiraj Chawla*
Senior Software Engineer
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

Phone: +91-20-30589522


On Fri, May 16, 2014 at 1:53 PM, Dave Page  wrote:

> Thanks Akshay. Dhiraj, can you review please? I'm a little busy right now.
>
> Thanks.
>
>
> On Thu, May 15, 2014 at 7:39 AM, Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi Dave
>>
>> I have fixed the escaping issue and tested it. It works fine for me.
>> Attached is the patch file, can you please review it.
>> If code looks good to you, can you please commit the code.
>>
>>
>> On Thu, May 8, 2014 at 2:34 PM, Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Sure.
>>>
>>>
>>> On Thu, May 8, 2014 at 1:37 PM, Dave Page  wrote:
>>>
 Akshay, can you look into the quoting problem please.

 On Thu, May 8, 2014 at 1:07 AM, Stephen Frost 
 wrote:
 > * Heikki Linnakangas (hlinnakan...@vmware.com) wrote:
 >> (forwarding to pgadmin-hackers)
 >
 > Ah.
 >
 >> On 05/07/2014 06:44 PM, Stephen Frost wrote:
 >> >* d...@isam.kiwi (d...@isam.kiwi) wrote:
 >> >>but when the credential contains the delimiter (colon) it fails to
 be
 >> >>read back out and app responds with "invalid credentials".
 >> >>
 >> >>x.x.x.x:5432:*:username:password:with:colons
 >> >
 >> >Per the fine documentation, you need to escape any such usage with a
 >> >backslash.  Please review:
 >>
 >> Stephen, you missed the context. pgadmin3 saves .pgpass, when you
 >> check the "store password" checkbox in the connection dialog. And
 >> apparantly pgadmin3 doesn't do that escaping properly.
 >
 > Wow, that's pretty rough.  Hopefully they'll be able to fix it soon.
 :)
 >
 > Thanks,
 >
 > Stephen



 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company

>>>
>>>
>>>
>>> --
>>> *Akshay Joshi*
>>> *Principal Software Engineer *
>>>
>>>
>>>
>>> *Phone: +91 20-3058-9517 <%2B91%2020-3058-9517> Mobile: +91 976-788-8246
>>> <%2B91%20976-788-8246>*
>>>
>>
>>
>>
>> --
>> *Akshay Joshi*
>> *Principal Software Engineer *
>>
>>
>>
>> *Phone: +91 20-3058-9517 <%2B91%2020-3058-9517> Mobile: +91 976-788-8246
>> <%2B91%20976-788-8246>*
>>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>