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 a
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 function by any other m
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 SQL committee is u
"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 principles of
program
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 like it, behave as f
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 Develope
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
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 fr
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 imp
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 subsc
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 directory
Try building the core
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
in
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
-Wdeclarat
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 adding the
> > scram-sha-256 authentication in hba.conf and
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
> password_encyption = scram-sha-256 in config
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 order to use scram authentication in
> > postgres 10
> >
>
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 pg server
>
> psql.bin: SCRAM
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 let
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
19 matches
Mail list logo
