Re: [GENERAL] Interesting streaming replication issue

(sorry for the top post, bitchy K9 Mail) James, are you sure you're scp'ing from the archive, not from pg_xlog? Regards, Gunnar "Nick" Bluth Am 27. Juli 2017 05:00:17 MESZ schrieb James Sewell <james.sew...@jirotech.com>: >Hi all, > >I've got two ser

Re: [GENERAL] Streaming Replication Without Downtime

(sorry for the toppost, mobile device) What you're looking for is pg_basebackup with - - xlog=stream, I guess. Regards, Nick Am 17. Februar 2017 14:06:36 MEZ schrieb Gabriel Ortiz Lour : >Hi all, >I've been searching for a way to initialize a new Hot Standby node

[GENERAL] Unexpected function behaviour with NULL and/or default NULL parameters

(userid:=null, sessionid:=null::uuid, locale:='en'); get_current_tac - NULL (1 row) I'm completely puzzled by this behaviour; at least it should cast the locale_specific value into the JSON output, shouldn't it? What am I missing? Any hints appreciated! - -- Gunnar Nick

Re: [GENERAL] Unexpected function behaviour with NULL and/or default NULL parameters

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 06.05.2015 um 09:57 schrieb David G. Johnston: Ooops, accidentaly replied to David directly... Wednesday, May 6, 2015, Gunnar Nick Bluth gunnar.bl...@pro-open.de mailto:gunnar.bl...@pro-open.de wrote: -BEGIN PGP SIGNED MESSAGE

Re: [GENERAL] Collation problem?

to get the correct sort order without recreating all my databases or initialize PGSQL? Sure (i.e., if you're on a half recent version): ALTER TABLE yourtable ALTER COLUMN yourcolumn COLLATE collation http://www.postgresql.org/docs/9.4/static/sql-altertable.html - -- Gunnar Nick Bluth RHCE/SCLA

Re: [GENERAL] Patched odbc_dfw for PG = 9.2 - compiles works but has issues with NULL representation in ODBC?!?

Am 19.04.2014 12:44, schrieb Gunnar Nick Bluth: Heillo, after stumbling across compile errors for odbc_fdw I realised it was still on the 9.1. level. I've patched it, based on the tds_fdw code (so it's still read-only). It does compile, and I think it is generally sane, however I'm

[GENERAL] Patched odbc_dfw for PG = 9.2

According notes have been added to the Foreign_data_wrappers WIKI page as well (no need for more people to try compiling it ;-). Cheers, -- Gunnar Nick Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bl...@pro-open.de

Re: [GENERAL] High RAM usage on postgres

, but it would get sent to psql of course. Regards, -- Gunnar Nick Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bl...@pro-open.de __ In 1984 mainstream users were choosing VMS over UNIX. Ten years later

Re: [GENERAL] PostgreSQL and a clustered file system

you too much, as the relevant I/O PG does is sync anyway. Just my 2p, -- Gunnar Nick Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bl...@pro-open.de __ In 1984 mainstream users were choosing VMS over UNIX. Ten years