Re: [GENERAL] Interesting streaming replication issue

2017-07-26 Thread Gunnar "Nick" Bluth
(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 : >Hi all, > >I've got two servers (A,B) which are part of a

Re: [GENERAL] Streaming Replication Without Downtime

2017-02-17 Thread Gunnar "Nick" Bluth
(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 with >Streaming Replicati

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

2015-05-06 Thread Gunnar "Nick" Bluth
-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 > mailto:gunnar.bl...@pro-open.de>> > wrote: > > -BEGIN PGP SIGNED

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

2015-05-06 Thread Gunnar "Nick" Bluth
(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" Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bl...@pro-ope

Re: [GENERAL] Collation problem?

2015-04-26 Thread Gunnar "Nick" Bluth
> letters.. So my guestion is if it is possible 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 ALTER COLUMN COLLATE http://www.postgresql.org/docs/9.4/static/sql-alt

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

2014-04-24 Thread Gunnar "Nick" Bluth
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 general

[GENERAL] Patched odbc_dfw for PG >= 9.2

2014-04-19 Thread Gunnar "Nick" Bluth
.com/bluthg/odbc_fdw 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 E

Re: [GENERAL] High RAM usage on postgres

2013-03-17 Thread Gunnar "Nick" Bluth
d show up in pg_relation_size and friends, 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 w

Re: [GENERAL] PostgreSQL and a clustered file system

2012-11-12 Thread Gunnar "Nick" Bluth
round, should your primary server fail. The journal replay should not hurt 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