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!
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 pg_stat_subscription. What i
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. See do_autovacuum().
--
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
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:
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 updated
> only.
> So, fr
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 cand
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,
Ugh.
> Thankfully thi
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: "char"[] @> unknown
>
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 parray_gin installed.
> [
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
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 thin
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:
http://www.postgresql.org/mailpre
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 paramet
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 segments that your logic
is
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 things correctly in this w
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 t
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 /usr/lo
18 matches
Mail list logo
