On 8/22/2019 9:15 PM, Tom Lane wrote:
Adrian Klaver writes:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
How can I start up the Cluster?
Is version 201906161 beta 2?
Yes:
Adrian Klaver writes:
> On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
>> How can I start up the Cluster?
>> Is version 201906161 beta 2?
> Yes:
>
On 8/22/19 7:12 PM, Ron wrote:
On 8/22/19 8:49 PM, Adrian Klaver wrote:
On 8/22/19 6:29 PM, Ron wrote:
On 8/22/19 7:08 PM, Adrian Klaver wrote:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought
beta 3 but now am not sure anymore)
Adrian,
On 8/22/2019 5:08 PM, Adrian Klaver wrote:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought
beta 3 but now am not sure anymore) running in Docker.
I have installed Postgres 12b3 as a Systemd service and am trying to
set
On 8/22/19 8:49 PM, Adrian Klaver wrote:
On 8/22/19 6:29 PM, Ron wrote:
On 8/22/19 7:08 PM, Adrian Klaver wrote:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought beta
3 but now am not sure anymore) running in Docker.
I have
On 8/22/19 6:29 PM, Ron wrote:
On 8/22/19 7:08 PM, Adrian Klaver wrote:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought
beta 3 but now am not sure anymore) running in Docker.
I have installed Postgres 12b3 as a Systemd service
On 8/22/19 7:08 PM, Adrian Klaver wrote:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought beta 3
but now am not sure anymore) running in Docker.
I have installed Postgres 12b3 as a Systemd service and am trying to set
the cluster
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought beta
3 but now am not sure anymore) running in Docker.
I have installed Postgres 12b3 as a Systemd service and am trying to set
the cluster to the same PGDATA. I have set the owner
I have a data directory that was created by Postgres 12 (I thought beta
3 but now am not sure anymore) running in Docker.
I have installed Postgres 12b3 as a Systemd service and am trying to set
the cluster to the same PGDATA. I have set the owner of the directory
to postgres:postrgres, and
Hi,
Need help from anyone in the team who has worked on pgwatch2.
Yesterday we installed pgwatch2 docker image and started the container.
We are running the pgwatch2 container from the database server itself -
Now we want to add our databases for monitoring using the admin interface:
We are
Good afternoon!
I am finding it difficult to understand how to maintain my BRIN index from
the docs. Specifically, this is the documentation on the
function brin_summarize_range which isn't clear to me:
brin_summarize_range(index regclass, blockNumber bigint) integer
- summarize the page
CREATE TABLE test ( id integer, data jsonb ) Partition by range (( data #>>
'{info,time}' ));
CREATE TABLE test_part1 PARTITION OF test
FOR VALUES FROM ('3') TO ('4');
INSERT INTO test VALUES (1,'{"info":[{"time":39814.0,"value":2},
{"time":39815.0,"value":3}]}');
Is there a way
Adrian,
On 8/22/2019 12:48 PM, Adrian Klaver wrote:
In addition to my previous post maybe change:
baseurl=https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-$releasever-$basearch
to:
On 8/22/19 12:35 PM, Igal @ Lucee.org wrote:
Adrian,
On 8/22/2019 12:22 PM, Adrian Klaver wrote:
On 8/22/19 11:29 AM, Igal @ Lucee.org wrote:
I have installed the CentOS 7 PGDG file from
https://yum.postgresql.org/repopackages.php
If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see:
#
On 8/22/19 12:35 PM, Igal @ Lucee.org wrote:
Adrian,
On 8/22/2019 12:22 PM, Adrian Klaver wrote:
On 8/22/19 11:29 AM, Igal @ Lucee.org wrote:
I have installed the CentOS 7 PGDG file from
https://yum.postgresql.org/repopackages.php
If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see:
#
Adrian,
On 8/22/2019 12:22 PM, Adrian Klaver wrote:
On 8/22/19 11:29 AM, Igal @ Lucee.org wrote:
I have installed the CentOS 7 PGDG file from
https://yum.postgresql.org/repopackages.php
If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see:
# PGDG Red Hat Enterprise Linux / CentOS /
I have installed the CentOS 7 PGDG file from
https://yum.postgresql.org/repopackages.php
If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see:
# PGDG Red Hat Enterprise Linux / CentOS / Scientific Linux stable
repositories:
[pgdg12]
name=PostgreSQL 12 $releasever - $basearch
On 8/22/19 11:29 AM, Igal @ Lucee.org wrote:
I have installed the CentOS 7 PGDG file from
https://yum.postgresql.org/repopackages.php
If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see:
# PGDG Red Hat Enterprise Linux / CentOS / Scientific Linux stable
repositories:
[pgdg12]
I have installed the CentOS 7 PGDG file from
https://yum.postgresql.org/repopackages.php
If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see:
# PGDG Red Hat Enterprise Linux / CentOS / Scientific Linux stable
repositories:
[pgdg12]
name=PostgreSQL 12 $releasever - $basearch
Why can I use an alias for group by and order by and not for having? I am
just wondering if there is some barrier to it being implemented, or if it
just hasn't been.
select
table_schema || '.' || table_name AS schema_qualified_table_name,
count( column_name ) as column_count
from
"Arnaud L." writes:
> Hi list
>
> On Windows, I have an unattended script that exports data overnight by
> issuing psql commands like :
> psql -f mycommands.sql
> whith mycommands.sql containing a bunch of \copy lines like :
> \copy (SELECT * FROM someview) TO
>
Le 22/08/2019 à 16:21, Adrian Klaver a écrit :
The only thing I can think of at the moment is to put the offending line
in a separate script and see what happens.
Then I think I'll first try to switch the line orders. I'll execute this
action last and see if it changes anything. If it
On 8/22/19 7:07 AM, Arnaud L. wrote:
Le 22/08/2019 à 16:00, Adrian Klaver a écrit :
The first thing I think of when seeing this sort of behavior on Windows
is anti-virus software. Doing you have any running on the machine?
You say it always hangs on the same line. Is that line doing something
Le 22/08/2019 à 16:00, Adrian Klaver a écrit :
The first thing I think of when seeing this sort of behavior on Windows
is anti-virus software. Doing you have any running on the machine?
You say it always hangs on the same line. Is that line doing something
different from the others? Say writing
On 8/22/19 1:47 AM, Arnaud L. wrote:
Hi list
On Windows, I have an unattended script that exports data overnight by
issuing psql commands like :
psql -f mycommands.sql
whith mycommands.sql containing a bunch of \copy lines like :
\copy (SELECT * FROM someview) TO
On Thu, 2019-08-22 at 09:01 -0400, Reid Thompson wrote:
> On Thu, 2019-08-22 at 08:25 -0400, Reid Thompson wrote:
> > On Wed, 2019-08-21 at 17:15 -0400, stan wrote:
> > > [EXTERNAL SOURCE]
> > >
> > >
> > >
> > > I have a situation where we need to import data, as an interim measure,
> > > from
On Thu, 2019-08-22 at 08:25 -0400, Reid Thompson wrote:
> On Wed, 2019-08-21 at 17:15 -0400, stan wrote:
> > [EXTERNAL SOURCE]
> >
> >
> >
> > I have a situation where we need to import data, as an interim measure,
> > from spreadsheets.
> >
> > I have read up on \copy and COPY, but I do not
On Wed, 2019-08-21 at 17:15 -0400, stan wrote:
> [EXTERNAL SOURCE]
>
>
>
> I have a situation where we need to import data, as an interim measure,
> from spreadsheets.
>
> I have read up on \copy and COPY, but I do not see that either of these can
> use the header from a CSV file to define a
28 matches
Mail list logo
