[GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols

G'day, we are quite excited about the parallelisation enhancements, and keen to try, but trying to build (using the same configure as we have used for 9.6) is giving some warnings and errors. The detail is below, but the oddity I'm really wondering about is the reference in the command to

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

On Sun, 2017-10-22 at 15:13 +0100, Martin Moore wrote: > 2017-10-22 14:08:28 UTC [2479-1] LOG: 0: database system > shutdown was interrupted; last known up at 2017-10-22 14:07:20 UTC There is something missing here. Last shutdown at 2017-10-22 14:07:20 UTC on which server? Then attempting

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

On Sun, Oct 22, 2017 at 11:13 PM, Martin Moore wrote: > I’ve migrated a running Debian Jessie system from a Google Compute instance > to a VMWare ESXi 6.5 system. How did you actually do this migration? It is really easy to finish with a corrupted instance if not doing

Re: [GENERAL] Backup strategy using 'wal_keep_segments'

On Mon, Oct 23, 2017 at 5:57 AM, Rhhh Lin wrote: > Is this approach feasible? Assuming obviously, we have sufficient disk space > to facilitate 1000 WAL files etc. You expose yourself to race conditions with such methods if a checkpoint has the bad idea to recycle past

[GENERAL] Backup strategy using 'wal_keep_segments'

Hi, Version 9.4... Per the PG docs, to facilitate continuous WAL archiving and PITR recovery... "To enable WAL archiving, set the wal_level configuration parameter to archive (or hot_standby), archive_mode to on, and specify the shell command to use in the archive_command configuration

Re: [GENERAL] parray_gin and \d errors in PG10

I wrote: > Or maybe what we should do is to avoid @> in favor of using > ('d' = any(stxkind)) Pushed that way. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] tgrm index for word_similarity

On Sat, Oct 21, 2017 at 10:01:56PM -0700, Igal @ Lucee.org wrote: > > 1) I thought that the whole idea behind indexes on expressions is that the > index would be used in a WHERE clause?  See > https://www.postgresql.org/docs/10/static/indexes-expressional.html - Am I > missing something? > I

Re: [GENERAL] How to get login user name and host name in pgaudit

On Sun, Oct 22, 2017 at 05:32:56AM -0700, rakeshkumar464 wrote: > I installed latest pgaudit (1.2) with pg10. I am testing it and I see that > it does not log the login user name and host name. > > For example, if user mary is running select * from sensitive_table, I want > Mary and the machine

Re: [GENERAL] parray_gin and \d errors in PG10

Justin Pryzby writes: > On Sun, Oct 22, 2017 at 02:36:12PM -0400, Tom Lane wrote: >> ... Possibly we could use >> (stxkind @> '{d}'::pg_catalog."char"[]) >> That works for me without parray_gin installed, but I wonder whether >> it fails due to ambiguity if you do have

Re: [GENERAL] parray_gin and \d errors in PG10

On Sun, Oct 22, 2017 at 02:36:12PM -0400, Tom Lane wrote: > Justin Pryzby writes: > > After installing parray_gin extension and pg_upgrading another instance, > > \d is failing like so: > > > [pryzbyj@database ~]$ psql ts -c '\d pg_class' > > ERROR: operator is not unique:

Re: [GENERAL] parray_gin and \d errors in PG10

Justin Pryzby writes: > After installing parray_gin extension and pg_upgrading another instance, > \d is failing like so: > [pryzbyj@database ~]$ psql ts -c '\d pg_class' > ERROR: operator is not unique: "char"[] @> unknown > LINE 6: (stxkind @> '{d}') AS ndist_enabled,

[GENERAL] parray_gin and \d errors in PG10

After installing parray_gin extension and pg_upgrading another instance, \d is failing like so: [pryzbyj@database ~]$ psql ts -c '\d pg_class' ERROR: operator is not unique: "char"[] @> unknown LINE 6: (stxkind @> '{d}') AS ndist_enabled, ^ HINT: Could not choose a best

Re: [GENERAL] Re: Restoring tables with circular references dumped to separate files

On Sat, Oct 21, 2017 at 10:48 PM, doganmeh wrote: ... > On another note, I used to take full backups (entire database), however > switched to table by table scheme in order to make it more VCS friendly. > Namely, so I only check into github the dumps of the tables that are

[GENERAL] Postgres 9.6 fails to start on VMWare

I’ve migrated a running Debian Jessie system from a Google Compute instance to a VMWare ESXi 6.5 system. Postgres won’t start, although returns [ok] : /etc/init.d/postgresql start 9.6 [ ok ] Starting postgresql (via systemctl): postgresql.service. 2017-10-22 14:08:28 UTC [2479-1] LOG:  0:

[GENERAL] How to get login user name and host name in pgaudit

I installed latest pgaudit (1.2) with pg10. I am testing it and I see that it does not log the login user name and host name. For example, if user mary is running select * from sensitive_table, I want Mary and the machine from where she ran in the log. It seems to log the ids which needs to be

Re: [GENERAL] Weird performance difference

On Sat, Oct 21, 2017 at 9:38 AM, Tom Lane wrote: > Also try explicitly ANALYZE'ing the foreign tables. I do not > believe auto-analyze will touch foreign tables ... Autovacuum and autoanalyze only process relations and matviews, discarding the rest when scanning pg_class.

Re: [GENERAL] A question on pg_stat_subscription view

Hello, You can find more information about that view and its columns. https://www.postgresql.org/docs/devel/static/monitoring-stats.html#pg-stat-subscription Regards, Gunce On 22 Oct 2017 Sun at 11:11 Önder Kalacı wrote: > Hi, > > I'm trying to understand the view

[GENERAL] A question on pg_stat_subscription view

Hi, I'm trying to understand the view pg_stat_subscription. What is the `latest_end_lsn` column? Is that the latest lsn flushed or lsn replied or something else? Thanks!