[GENERAL] pgpool II, streaming replication and HA

e that A host is "bad one" and stop routing queries to A? -- Best regards, Alexander Pyhalov, system administrator of Southern Federal University IT department -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgpool II, streaming replication and HA

it to a new standby connecting to the current primary on B. You can do it by either "online recovery" feature of pgpool or do it manually using pg_basebackup etc. In the latter case, you need to "attach" 'the new standby to make it online by using pcp_attach_node. Thank you

[GENERAL] pgpool-II: cannot use serializable mode in a hot standby

predicate.c:1588 STATEMENT: DISCARD ALL It seems pgpool sends these statements to the slave server. Is it pgpool/application misconfiguration or pgpool issue? -- Best regards, Alexander Pyhalov, system administrator of Southern Federal University IT department -- Sent via pgsql-general mailing l

Re: [GENERAL] pgpool-II: cannot use serializable mode in a hot standby

On 04/12/2016 16:50, Adrian Klaver wrote: On 04/12/2016 01:06 AM, Alexander Pyhalov wrote: Hi. We have application which explicitly does set default_transaction_isolation to 'serializable' . It is connected to PostgreSQL master/slave cluster through pgpool-II (pgpool2 3.4.3-1.pgdg

Re: [GENERAL] pgpool-II: cannot use serializable mode in a hot standby

Tatsuo Ishii писал 13.04.2016 02:36: On 04/12/2016 16:50, Adrian Klaver wrote: On 04/12/2016 01:06 AM, Alexander Pyhalov wrote: I understand. I mean perhaps pgpool shouldn't forward these statements to slaves. Yeah, PostgreSQL used to accept the command on standbys (at least in 9.0)

[GENERAL] DBMS upgrade and backups

s the preferred way to deal with this issue? -- Best regards, Alexander Pyhalov, system administrator of Computer Center of South Federal University -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] DBMS upgrade and backups

st of backup archive. -- Best regards, Alexander Pyhalov, system administrator of Computer Center of South Federal University -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Autocommit off - commits/rollbacks

just do: > \set ON_ERROR_ROLLBACK on -- Best regards, Alexander Pyhalov, system administrator of Computer Center of Southern Federal University -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] FreeBSD/Postgres/Apache+PHP

Hello. When you jail a process, all its attempt to bind to 127.0.0.1 address will be unsuccessful, and all its attempt to bind to * (all addresses) will be successful, but in fact it will bind only to jail's IP. So, when you try to connect to jail's pgsql from jail process will use jail's ip a

[GENERAL] I don't understand something...

ees where employee_id not in (select manager_id from employees) (query 3); count --- 0 (1 row) I don't understand why queries 1 and 3 give different results. They seems to be the same... Could someone explain the difference? -- Best regards, Alexander Pyhalov, system admin

Re: [GENERAL] I don't understand something...

vious. Thanks. It's confusing, that IN check works as expected, but NOT IN works this way... -- Best regards, Alexander Pyhalov, system administrator of Computer Center of Southern Federal University -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] Bulk processing & deletion

from the table Hello. Maybe you can just do begin; delete from . WHERE ... RETURNING *;, process records and issue COMMIT after processing? -- Best regards, Alexander Pyhalov, system administrator of Computer Center of Southern Federal University -- Sent via pgsql-general mailing list

[GENERAL] log database in which error occurs

/log/postgresql/db_$dbname.log . -- Best regards, Alexander Pyhalov, system administrator of Computer Center of South Federal University -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] log database in which error occurs

A. Kretschmer wrote: May 11 01:36:46 pgsql pgsql[73794]: [7-3] STATEMENT: select count(*) from forum_msg where grp_id=6709 (200 ok) ACCEPTED and is_blocked='f' Are there any ways to log database, to which invalid query was issued ? Sure: log_line_prefix = '%t ' # special v

Re: [GENERAL] Redundant database objects.

Hello. When we moved old projects from postgresql 7.x to 8.4, I just looked at modification time for files in base// . So, I could determine, that some databases were inactive (precisely,not updated) for about a year and move them to archive... Andrew Bartley wrote: Is there an effective way

[GENERAL] Get bytes sent to client

size of query responses... -- Best regards, Alexander Pyhalov, system administrator of Computer Center of South Federal University -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 8.3 PL/pgSQL comparing arbitrary records

Hello. It seems that this works (I made tests on permanent table, postgresql 8.4.0): CREATE OR REPLACE FUNCTION track_updates() RETURNS TRIGGER AS $$ DECLARE BEGIN IF TG_OP = 'UPDATE' THEN IF NEW IS NOT DISTINCT FROM OLD THEN RAISE NOTICE 'OLD and NEW are the same!';

[GENERAL] Binary compatibility

Hello. We have FreeBSD/amd64 PostgreSQL 9.0 server and would like to move data to Linux/amd64 PostgreSQL 9.0 server. Are databases on these systems binary compatible? Can I just transfer datafiles or I have to do full export/import? -- Best regards, Alexander Pyhalov, system administrator of