Re: [GENERAL] archive_command not being executed

I'd come to the same conclusion Jeremy had about 9.5 being the first version with the 'always' option for archive_mode. Looking at pg_receivexlog, that might work, but with me being a total noob I'm wary of the various steps I'd have to take in going from: Master -> streaming replication to

Re: [GENERAL] PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast"

On Tue, Nov 14, 2017 at 12:05 AM, Tom Lane wrote: > y39chen writes: >> We encounter one problem that PostgreSQL walsender process doesn't exist >> after "pg_ctl stop -m fast". >> Uses PostgreSQL 9.6.2 > > There was a fix in 9.6.4 that's at least

Re: [GENERAL] archive_command not being executed

On Tue, Nov 14, 2017 at 8:56 AM, Jeremy Schneider wrote: > From my reading of the docs and commit logs, standby databases > couldn't archive their WALs until 9.5. pg_receivexlog is available in 9.3. You could leverage your archives with it easily, by for example

Re: [GENERAL] archive_command not being executed

Hi Eric, Thanks for using PostgreSQL! On Fri, Nov 10, 2017 at 9:26 AM, Paul Jungwirth wrote: > Oh this has happened to me before. :-) On SB1 you need to set > archive_mode to always (not on). Otherwise it is ignored when running as a > standby. It looks to me

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På tirsdag 14. november 2017 kl. 00:44:11, skrev Peter Geoghegan >: On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh wrote: > When sorting on text, we're usually doing so using an multi-column index, like for instance "CREATE INDEX

Re: [GENERAL] PG-10 + ICU and abbreviated keys

On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh wrote: > When sorting on text, we're usually doing so using an multi-column index, > like for instance "CREATE INDEX xxx ON my_table (lower(name) ASC, created > ASC)". Will abbreviated keys help here? Yes, they'll help

[GENERAL] "Cascading Logical Replication" from a physical replica

Hi, as of PG10, it is not possible to create logical replication slots on standby servers. Should that fact probably be mentioned more explicitly in https://www.postgresql.org/docs/10/static/logical-replication.html ? There seems to be work by Craig Ringer going on, but that doesn't seem

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 22:28:40, skrev Peter Geoghegan >: On Mon, Nov 13, 2017 at 12:48 PM, Andreas Joseph Krogh wrote: > Thanks. As the person that worked on abbreviated keys, I'd like to hear about how you get with this. How

Re: [GENERAL] PG-10 + ICU and abbreviated keys

On Mon, Nov 13, 2017 at 12:48 PM, Andreas Joseph Krogh wrote: > Thanks. As the person that worked on abbreviated keys, I'd like to hear about how you get with this. How much faster is it for you? I don't usually get to hear about this, because most users don't notice that

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 21:46:08, skrev Peter Geoghegan >: On Mon, Nov 13, 2017 at 12:40 PM, Peter Geoghegan wrote: >> Do I have to explicitly specify collation when using ORDER by on that column for index and abbreviated keys to be

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 21:40:47, skrev Peter Geoghegan >: On Mon, Nov 13, 2017 at 11:48 AM, Andreas Joseph Krogh wrote: > Ok, so I have to explicitly specify like this: > > create table test(id serial primary key, name varchar

Re: [GENERAL] PG-10 + ICU and abbreviated keys

On Mon, Nov 13, 2017 at 12:40 PM, Peter Geoghegan wrote: >> Do I have to explicitly specify collation when using ORDER by on that column >> for index and abbreviated keys to be used? > > Only if you didn't define the column with a per-column collation initially. BTW, if you

Re: [GENERAL] PG-10 + ICU and abbreviated keys

On Mon, Nov 13, 2017 at 11:48 AM, Andreas Joseph Krogh wrote: > Ok, so I have to explicitly specify like this: > > create table test(id serial primary key, name varchar collate "nb_NO" not > null); That doesn't look like an ICU locale. You may mean "nb-NO-x-icu". But

[GENERAL] Logical replication + before trigger = ERROR: attempted to lock invisible tuple

Hi, I'm trying to execute a BEFORE UPDATE trigger for my logical replication subscription with Postgresql 10.1 but the apply worker crashes with: ERROR: attempted to lock invisible tuple The trigger creation: CREATE TRIGGER customers_anonymize_before_update BEFORE UPDATE ON customers FOR

Re: [GENERAL] PG-10 + ICU and abbreviated keys

På mandag 13. november 2017 kl. 19:07:53, skrev Peter Geoghegan >: On Mon, Nov 13, 2017 at 12:27 AM, Andreas Joseph Krogh wrote: > In PG-10, with ICU enabled, is abbreviated keys now enabled? Yes. ICU will use abbreviated keys on every

Re: [GENERAL] PG-10 + ICU and abbreviated keys

On Mon, Nov 13, 2017 at 12:27 AM, Andreas Joseph Krogh wrote: > In PG-10, with ICU enabled, is abbreviated keys now enabled? Yes. ICU will use abbreviated keys on every platform, including Windows. > If so, using locale=nb_NO.UTF-8, do I have to use a ICU-specific locale to

Re: [GENERAL] PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast"

y39chen writes: > We encounter one problem that PostgreSQL walsender process doesn't exist > after "pg_ctl stop -m fast". > Uses PostgreSQL 9.6.2 There was a fix in 9.6.4 that's at least related to this problem. It would be interesting to see if you can still reproduce

Re: [GENERAL] sync the data's from catalog table

Hi, Whenever the postgres user is trying to modify the user account's password column in pg_authid table, we need to maintain a trigger in catalog table (pg_authid) where it pop up the the "password column has been restricted and it should not be modified". Is there any possible for the above

Re: [GENERAL] PG-10 + ICU and abbreviated keys

On 11/13/2017 09:27 AM, Andreas Joseph Krogh wrote: >   > In PG-10, with ICU enabled, is abbreviated keys now enabled? >   Hello, I think yes : src/backend/utils/adt/varlena.c 1876 /* 1877 * Unfortunately, it seems that abbreviation for non-C collations is 1878 * broken on many

Re: [GENERAL] pg on Debian servers

On 12/11/17 19:15, Karsten Hilbert wrote: On Sat, Nov 11, 2017 at 01:03:18PM +, Mark Morgan Lloyd wrote: Several legacy programs written in Delphi ground to a halt this morning, which turned out to be because a Debian system had updated its copy of PostgreSQL and restarted the server,

[GENERAL] missing public on schema public

Hi We recently upgraded from 9.1 to 9.6 (now 9.6.6) and have, after dump/restore on 9.6, experienced the loss of public priviliges on schema public. Is this a "feature" or some kind of bug ? I have found a thread here that looks sortof similar with subject: "[GENERAL] intentional or

Re: [GENERAL] sync the data's from catalog table

Dinesh kumar wrote: > How can I sync the data's from pg_authid to manually created table (user > table) whenever the update or insert happens on pg_authid table. You cannot do this, because you cannot define triggers on catalog tables. The question is: Why do you want to do this? What are you

[GENERAL] PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast"

We encounter one problem that PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast". Uses PostgreSQL 9.6.2 Steps: 1)active postgres server is up; 2)standby postgres intance take pg_basebackup 3)usin command "pg_ctl stop -W -m fast -D /mnt/db/DBTestPostgres/db_data" to stop

[GENERAL] PG-10 + ICU and abbreviated keys

Hi.   In PG-10, with ICU enabled, is abbreviated keys now enabled?   If so, using locale=nb_NO.UTF-8, do I have to use a ICU-specific locale to take advantage of abbreviated keys?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com