[GENERAL] phpPgAdmin 6 on a MAC (High Sierra)

Apple has added PostgreSQL support to php in High Sierra. PhpPgAdmin seems to have died at Version 5.1 and it does not play nice with php 7.x. There is a fork called phpPgAdmin 6. I have been able to get the interface up but selecting a database results in an error. My php-foo is weak...has

Re: [GENERAL] Functions and Parentheses

On 10/6/2017 3:10 PM, Joshua D. Drake wrote: On 10/06/2017 02:33 PM, Tom Lane wrote: "Igal @ Lucee.org" writes: How come `current_date` has no parenthesis but `clock_timestamp()` does? Because the SQL standard says that CURRENT_DATE doesn't have parentheses. It is a

Re: [GENERAL] Functions and Parentheses

On 10/06/2017 02:33 PM, Tom Lane wrote: "Igal @ Lucee.org" writes: How come `current_date` has no parenthesis but `clock_timestamp()` does? Because the SQL standard says that CURRENT_DATE doesn't have parentheses. It is a function by any other measure, though. (AFAICT, the

Re: [GENERAL] Functions and Parentheses

"Igal @ Lucee.org" writes: > How come `current_date` has no parenthesis but `clock_timestamp()` does? Because the SQL standard says that CURRENT_DATE doesn't have parentheses. It is a function by any other measure, though. (AFAICT, the SQL committee is unacquainted with any

Re: [GENERAL] Functions and Parentheses

On Fri, Oct 6, 2017 at 2:18 PM, Igal @ Lucee.org wrote: > Hi, > > Is current_date a function? It's a bit puzzling to me since there are no > parentheses after it, i.e. > > SELECT current_date; > > And not > > SELECT current_date(); -- syntax error > ​ It, and the others

[GENERAL] Functions and Parentheses

Hi, Is current_date a function?  It's a bit puzzling to me since there are no parentheses after it, i.e.   SELECT current_date; And not   SELECT current_date();  -- syntax error How come `current_date` has no parenthesis but `clock_timestamp()` does? Thanks, Igal Sapir Lucee Core

Re: [GENERAL] Strange checkpoint behavior - checkpoints take a long time

Further updates: Yesterday checkpoints were finishing more or less on time with the configuration for 25 minutes out of 30 minutes, taking 26 minutes at most. So for today I reduced the time reserved for checkpoint writes to 20 minutes out of 30 minutes, by setting checkpoint_completion_target

Re: [GENERAL] delete a file everytime pg server starts/crashes

Actually if the name of the file doesn't matter you could put it into $PGDATA/pg_stat and name it global.stat. When postgres stops (clean or because of failure), replaces the file with his own. So your content will be erased. I'm not sure it's completely safe but works in simple test. -- Sent

Re: [GENERAL] Postgresql CDC tool recommendations ?

On Thu, Oct 05, 2017 at 10:28:31AM -0700, avi Singh wrote: > Any recommendation on a good CDC tool that can be used to push > postgresql changes to Kafka in json format ? There are quite a few WAL->JSON type tools out there. E.g., https://github.com/eulerto/wal2json I expect this to

Re: [GENERAL] delete a file everytime pg server starts/crashes

Look at inotify: https://github.com/rvoicilas/inotify-tools You can check for instance if postmaster.pid exists. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] compiling postgres_fdw fails for 9.6.5

Sandeep Gupta writes: > I downloaded the source, configured it with prefix=install_dir and > then moved to contrib/postgres_fdw dir. > However make fails with following error: > ../../src/include/utils/elog.h:71:28: fatal error: utils/errcodes.h: > No such file or

[GENERAL] Connection utilisation for pglogical

Ahead of setting up a testing environment to tryout pglogical, I'm keen to learn of the connection requirements for pglogical publisher and subscribers. Our use case is a cluster of (say) 200 databases, and we would like to look into aggregating data from a certain table using a row filter hook

[GENERAL] compiling postgres_fdw fails for 9.6.5

Hello, I am on Cent OS 6.8 machine. The Postgres is already installed in some install_dir/. I downloaded the source, configured it with prefix=install_dir and then moved to contrib/postgres_fdw dir. However make fails with following error: gcc -Wall -Wmissing-prototypes -Wpointer-arith

Re: [GENERAL] Regarding scram authentication libpq version 10 or more

On Fri, Oct 6, 2017 at 5:56 PM, Michael Paquier wrote: > On Fri, Oct 6, 2017 at 8:56 PM, Durgamahesh Manne > wrote: > > i have already read complete info about New Postgres 10 in postgres.org > and > > i have tried to access server by

Re: [GENERAL] Regarding scram authentication libpq version 10 or more

On Fri, Oct 6, 2017 at 8:56 PM, Durgamahesh Manne wrote: > i have already read complete info about New Postgres 10 in postgres.org and > i have tried to access server by adding the > scram-sha-256 authentication in hba.conf and also have already set >

Re: [GENERAL] Regarding scram authentication libpq version 10 or more

On Fri, Oct 6, 2017 at 3:40 PM, Michael Paquier wrote: > On Fri, Oct 6, 2017 at 5:44 PM, Durgamahesh Manne > wrote: > > This is regarding scram authentication libpq version 10. From which > site i > > can download to configure libpq in

Re: [GENERAL] Regarding scram authentication libpq version 10 or more

On Fri, Oct 6, 2017 at 5:44 PM, Durgamahesh Manne wrote: > This is regarding scram authentication libpq version 10. From which site i > can download to configure libpq in order to use scram authentication in > postgres 10 > > i got below error while i check to access

[GENERAL] Regarding scram authentication libpq version 10 or more

Hi sir This is regarding scram authentication libpq version 10. From which site i can download to configure libpq in order to use scram authentication in postgres 10 i got below error while i check to access pg server psql.bin: SCRAM authentication requires libpq version 10 or more please

Re: [GENERAL] delete a file everytime pg server starts/crashes

That seems like an odd requirement and I don't think PostgreSQL can do it itself, because if postgresql should crash properly then the process that should write/remove that file would also crash The simplest way would be to write a cronjob that connects to the database and does a simple query