Re: [GENERAL] Replication with 9.4

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. >>>

Re: [GENERAL] Replication with 9.4

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

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

Greetings To : There was an error in my previous posting -- apologies -- please ignore the posting. Steve

Re: [GENERAL] postgresql doesn't start

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

Re: [GENERAL] Replication with 9.4

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 >

[GENERAL] Replication with 9.4

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

Re: [GENERAL] postgresql doesn't start

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

Re: [GENERAL] Replication with 9.4

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

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

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.

Re: [GENERAL] Replication with 9.4

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

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

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

Re: [GENERAL] Replication with 9.4

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 >>

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

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

Re: [GENERAL] Replication with 9.4

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

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

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