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
'\\windowsserver\windowsshare\somefile.csv'
When I run this scrip
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 ne
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 se
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 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
'\\windowsserver\windowsshare
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 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
d
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 doesn't,
"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
> '\\windowsserver\windowsshare\some
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
information_schem
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
baseurl=https:
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]
name=Postgr
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
baseurl=https:
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 / Scient
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:
# P
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:
# P
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:
baseurl=https://download.postgresql.org/pub/repos/testing/yum/12/redhat/rhel-$releasever-$basear
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 to
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 ran
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 op
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 t
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 o
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 t
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 and
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 instal
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 th
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) ru
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 the cluster
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:
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/catalog/catversion.h;h=fe44cae3ff453ccc02e6c56548c9311b5777bf1f;hb=0ab7110bcbcce
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:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/catalog/catversion.h;h=fe44cae3ff453ccc02e6c5654
Le 22/08/2019 à 20:00, Jerry Sievers a écrit :
Is the overnight run being done as the same DB user you are testing
with?
If not, then perhaps the automated user deviates in resource settings
and/or permissions, in turn resulting in sluggish performance caused by
thrashing and/or inferior query p
31 matches
Mail list logo
