Re: [GENERAL] pg_restore load data

The command is COPY, not load. Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Ron Johnson Date: 11/16/17 16:07 (GMT-05:00) To: pgsql-general@postgresql.org Subject: [GENERAL] pg_restore load data Hi, v9.2.7  (Yes, I know, it's old.  Noth

Re: [GENERAL] Upgrade method from 9.2 to 10 ?

You can use Slony to replicate between different major versions.  Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Bruce Momjian Date: 6/16/17 16:18 (GMT-05:00) To: Paul Jones Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Upgrade

Re: [GENERAL] Sequential parallel scan / agg

Have you tried:CREATE TABLE blah AS SELECT ...  ? Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: James Sewell Date: 11/13/16 18:04 (GMT-05:00) To: pgsql-general Subject: [GENERAL] Sequential parallel scan / agg Hi all, I have a customer

Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1

It's simple just look in recovery. conf on slave and put stated trigger. then slave becomes stand alone.  Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Adrian Klaver Date: 10/26/16 19:50 (GMT-05:00) To: Michael Paquier , Joanna Xu Cc:

Re: [GENERAL] My Postgresql is inaccessible in Windows 8.1

If Postgresql were running, then he would have not had the problem. Would he? Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Adrian Klaver Date: 8/3/16 13:01 (GMT-05:00) To: Melvin Davidson Cc: "Edson F. Lidorio" , pgsql-general@postgres

Fwd: Re: [GENERAL] Add relcreated (timestamp) column to pg_class catalog to record the time an object was created

G. Johnston wrote: leaving off-list... On Wednesday, April 20, 2016, melvin6925 wrote: You are correct, nothing has changed. This is a very simple request and should be easy to implement. I have yet to hear a valid, logical argument against it. In fact. This has been implemented in both Oracle a

Re: [GENERAL] strange sql behavior

And were _your_ queries run on the same day at the same time within a few seconds of each other? Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Yu Nie Date: 2/1/2016 15:01 (GMT-05:00) To: melvin6925 Cc: Bill Moran , pgsql-gen

Re: [GENERAL] strange sql behavior

Thanks Bill.Also, it's very important to include the headers with the queries! Marco,There is no top secret information that is requested, so please do not edit the output. Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Bill Moran Date: 2/1/2

Re: [GENERAL] temporary indexes?

What Adrian is saying is that there is no need for "temporary" indexes. You can create the idxs on a temp table and they get dropped when you drop the table. Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Adrian Klaver Date: 10/21/2015 14:5

Re: [GENERAL] FW: Constraint exclusion in partitions

Did you remember to set  constraint_exclusion = on and reload the .conf ? Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: Daniel Begin Date: 05/23/2015 14:37 (GMT-05:00) To: pgsql-general@postgresql.org Subject: Re: [GENERAL] FW: Constra