Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Michael Paquier
On Sun, Oct 4, 2015 at 6:38 AM, Madovsky wrote: > On 10/3/2015 6:55 AM, Michael Paquier wrote: >> On Sat, Oct 3, 2015 at 10:20 PM, Madovsky wrote: >> Requesting the master would be necessary, still I don't really get why >> you don't want to query the master for read queries... You could for >> exa

Re: [GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread Adrian Klaver
On 10/03/2015 02:50 PM, Steve Petrie, P.Eng. wrote: Hello Rob, Thanks for your prompt response -- much appreciated. I actually re-submitted my questions to with a correction. After the "BEGIN;" query and the pg_get_result(...); all calls to function pg_result_error_field(...) are returning typ

Re: [GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread Steve Petrie, P.Eng.
Hello Rob, Thanks for your prompt response -- much appreciated. I actually re-submitted my questions to with a correction. After the "BEGIN;" query and the pg_get_result(...); all calls to function pg_result_error_field(...) are returning type NULL (not type boolean, as I reported erroneousl

Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Madovsky
On 10/3/2015 6:55 AM, Michael Paquier wrote: On Sat, Oct 3, 2015 at 10:20 PM, Madovsky wrote: On 10/3/2015 4:48 AM, Michael Paquier wrote: On Sat, Oct 3, 2015 at 8:09 PM, Madovsky wrote: I would like to fix a issue I'm facing of with the version 9.4 streaming replication. is it possible t

Re: [GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread rob stone
On Sat, 2015-10-03 at 08:18 -0400, Steve Petrie, P.Eng. wrote: > Greetings To : > > I am migrating a PHP web application to use PostgreSQL instead of > MySQL. > > And I have never used PostgreSQL before. > > I have two questions about function pg_result_error_field(...); > > An extensive se

Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Michael Paquier
On Sat, Oct 3, 2015 at 10:20 PM, Madovsky wrote: > > > On 10/3/2015 4:48 AM, Michael Paquier wrote: >> >> On Sat, Oct 3, 2015 at 8:09 PM, Madovsky wrote: >>> >>> I would like to fix a issue I'm facing of with the version 9.4 streaming >>> replication. >>> is it possible to set on the fly the sync

Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Madovsky
On 10/3/2015 4:48 AM, Michael Paquier wrote: On Sat, Oct 3, 2015 at 8:09 PM, Madovsky wrote: I would like to fix a issue I'm facing of with the version 9.4 streaming replication. is it possible to set on the fly the synchronous commit on the master (or standby?) which only sync commit the hot

Re: [GENERAL] postgresql doesn't start

2015-10-03 Thread Adrian Klaver
On 10/03/2015 05:50 AM, Paolo De Michele wrote: hi there, thanks a lot so, I'm using docker on ubuntu 14.04 about permissions: # ls -la /var/lib/postgresql/9.3/main total 72 drwx-- 28 postgres postgres 4096 Oct 3 12:41 . drwxr-xr-x 4 postgres postgres 4096 Oct 1 11:59 .. -rwx-- 1 po

Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Madovsky
Hi On 10/3/2015 5:46 AM, Edson Richter wrote: Madovsky escreveu > Hi, > > I would like to fix a issue I'm facing of with the version 9.4 streaming > replication. > is it possible to set on the fly the synchronous commit on the master > (or standby?) > which only sync commit the ho

Re: [GENERAL] postgresql doesn't start

2015-10-03 Thread Paolo De Michele
hi there, thanks a lot so, I'm using docker on ubuntu 14.04 about permissions: # ls -la /var/lib/postgresql/9.3/main total 72 drwx-- 28 postgres postgres 4096 Oct 3 12:41 . drwxr-xr-x 4 postgres postgres 4096 Oct 1 11:59 .. -rwx-- 1 postgres postgres4 Mar 21 2015 PG_VERSION drwx-

Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Edson Richter
Madovsky escreveu > Hi, > > I would like to fix a issue I'm facing of with the version 9.4 streaming > replication. > is it possible to set on the fly the synchronous commit on the master > (or standby?) > which only sync commit the hot standby node used by the client who has a > r

[GENERAL] *** CORRECTION -- PLEASE IGNORE *** BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread Steve Petrie, P.Eng.
Greetings To : There was an error in my previous posting -- apologies -- please ignore the posting. Steve

[GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

2015-10-03 Thread Steve Petrie, P.Eng.
Greetings To : I am migrating a PHP web application to use PostgreSQL instead of MySQL. And I have never used PostgreSQL before. I have two questions about function pg_result_error_field(...); An extensive search of the web, did not yield a solution to my problem. * * * * * * My PHP program i

Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Michael Paquier
On Sat, Oct 3, 2015 at 8:09 PM, Madovsky wrote: > I would like to fix a issue I'm facing of with the version 9.4 streaming > replication. > is it possible to set on the fly the synchronous commit on the master (or > standby?) > which only sync commit the hot standby node used by the client who has

[GENERAL] Replication with 9.4

2015-10-03 Thread Madovsky
Hi, I would like to fix a issue I'm facing of with the version 9.4 streaming replication. is it possible to set on the fly the synchronous commit on the master (or standby?) which only sync commit the hot standby node used by the client who has a read only sql session on? example: node1 node2