On Tue, Oct 09, 2018 at 03:26:35PM +0800, magodo wrote:
> Yes, but does this differ whether I'm archiving a general WAL or
> archiving the backup history? I mean if user doesn't handle duplicate
> archive, then pg_wal will still be filled up when archiving WAL.
A WAL segment has a unique name, and
On Tue, 2018-10-09 at 11:45 +0900, Michael Paquier wrote:
> (Please do not forget to add the community mailing list in CC.)
>
> On Tue, Oct 09, 2018 at 10:33:56AM +0800, magodo wrote:
> > Since the backup history aims to aid administrator to identify the
> > point from which wal archive should b
On Tue, 2018-10-09 at 12:53 +0900, Michael Paquier wrote:
> On Tue, Oct 09, 2018 at 11:45:50AM +0800, magodo wrote:
> > Yet, I am still not so clear how does the bloat of pg_wal happen?
> > Do
> > you mean pg_wal will be filled up by many .backup(s)?
>
> If your archive_command is for example a
On Tue, 2018-10-09 at 16:55 +0900, Michael Paquier wrote:
> On Tue, Oct 09, 2018 at 03:26:35PM +0800, magodo wrote:
> > Yes, but does this differ whether I'm archiving a general WAL or
> > archiving the backup history? I mean if user doesn't handle
> > duplicate
> > archive, then pg_wal will stil
Good evening,
I am trying to SELECT ARRAY_AGG into an array from 2 tables.
But unfortunately here is what I get in PostgreSQL 10.5:
SELECT ARRAY_AGG(hashed)
FROM words_nouns
WHERE added > TO_TIMESTAMP(1539100913)
UNION
SELECT ARRAY_AGG(hashed)
FROM w
On Tue, Oct 9, 2018 at 9:32 AM Alexander Farber
wrote:
>
> SELECT ARRAY_AGG(hashed)
>FROM words_nouns
>WHERE added > TO_TIMESTAMP(1539100913)
> UNION
> SELECT ARRAY_AGG(hashed)
> FROM words_verbs
> WHERE added > TO_TIMESTAMP(15391009
Hello,
I've an issue with foreign table using tds_fdw from PostgreSQL 10 to Sybase
ASE 15.7.
The issue is, that primary key, which I have to use for my predicate is in
Sybase data type binary.
Foreign table maps ID column from Sybase binary to PostgreSQL BYTEA.
Simple select is smooth:
[local]:
Hi all
I installed pglogger (https://sourceforge.net/projects/pglogger/) and
try to insert into the "level" table as user "act" but it fails
claiming insufficient privileges even though insert is granted to
public (see below). What am I missing?
Kind regards Thiemo
thiemo @ thiemos-to
## Thiemo Kellner (thi...@gelassene-pferde.biz):
> I installed pglogger (https://sourceforge.net/projects/pglogger/) and
> try to insert into the "level" table as user "act" but it fails
> claiming insufficient privileges even though insert is granted to
> public (see below). What am I missing?
S
On 10/9/18 12:07 PM, Aleš Zelený wrote:
Hello,
I've an issue with foreign table using tds_fdw from PostgreSQL 10 to
Sybase ASE 15.7.
The issue is, that primary key, which I have to use for my predicate is
in Sybase data type binary.
Foreign table maps ID column from Sybase binary to Postgr
I have several different logs. I'm not sure which is the 'right' one. None
of them show anything other than routine start and stop activity, even
after I added a single Entry document. However, I did notice despite the
'incomplete startup', the last one is the only one that mentions listening
on an
On 10/9/18 3:25 PM, Malik Rumi wrote:
I have several different logs. I'm not sure which is the 'right' one.
None of them show anything other than routine start and stop activity,
even after I added a single Entry document. However, I did notice
despite the 'incomplete startup', the last one is
Can anyone here tell me whether or not the CopyManager facility in JDBC
via org.postgresql:postgresql:42.1.4 is internally multithreaded?
Running on CentOS 7 (all participants), java8, postgres 10.5
Quoting Christoph Moench-Tegeder :
Schema privileges.
provileges. I'd guess you miss USAGE on schema logger.
Thanks for the hint. I did not know about a usage grant coming from
Oracle, so I completely ignored the possibility of the absence of a
different grant. I just read the documentat
On Tuesday, October 9, 2018, Thiemo Kellner
wrote:
>
> Does it not say you do not need the usage privilege as you can query the
> data catalog anyway to get the object's details? And in deed, DBeaver
> queries the details of the object without the usage privilege.
Basically lacking USAGE does no
I am running three instances (under different users) on a RHEL 7 server to
support a vendor product.
In the defined services, the start & stop scripts work fine when invoked with
systemctl {start|stop} whatever.service but we have automated monthly patching
which does a reboot.
Looking in /va
Hi Team,
I am working on a requirement, where I need to log each and every
operation on the master db. So I was thinking if I could do with pg_logical
by setting my master db as publisher and setting a new db as subscriber and
dropping the subscription there after. I am wondering, how to get the
o
On 10/9/18 11:06 AM, Bryce Pepper wrote:
I am running three instances (under different users) on a RHEL 7 server
to support a vendor product.
In the defined services, the start & stop scripts work fine when invoked
with systemctl {start|stop} whatever.service but we have automated
monthly pa
Quoting "David G. Johnston" :
Layers of security. But yes it is generally sufficient enough to
simply allow usage on scheme without much
thought while ensuring contained objects are sufficiently secured.
Thanks :-)
19 matches
Mail list logo
