Re: [GENERAL] pg_restore load data

2017-11-16 Thread melvin6925
The command is COPY, not load. Sent via the Samsung Galaxy S® 6, an AT 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

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

2017-06-16 Thread melvin6925
You can use Slony to replicate between different major versions.  Sent via the Samsung Galaxy S® 6, an AT 4G LTE smartphone Original message From: Bruce Momjian Date: 6/16/17 16:18 (GMT-05:00) To: Paul Jones Cc:

Re: [GENERAL] Sequential parallel scan / agg

2016-11-13 Thread melvin6925
Have you tried:CREATE TABLE blah AS SELECT ...  ? Sent via the Samsung Galaxy S® 6, an AT 4G LTE smartphone Original message From: James Sewell Date: 11/13/16 18:04 (GMT-05:00) To: pgsql-general Subject: [GENERAL]

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

2016-10-26 Thread melvin6925
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 4G LTE smartphone Original message From: Adrian Klaver Date: 10/26/16 19:50 (GMT-05:00) To: Michael

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

2016-08-03 Thread melvin6925
If Postgresql were running, then he would have not had the problem. Would he? Sent via the Samsung Galaxy S® 6, an AT 4G LTE smartphone Original message From: Adrian Klaver Date: 8/3/16 13:01 (GMT-05:00) To: Melvin Davidson

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

2016-04-20 Thread melvin6925
gth discussion on code of conduct. On Wed, Apr 20, 2016 at 2:58 PM, David G. Johnston <david.g.johns...@gmail.com> wrote: leaving off-list... On Wednesday, April 20, 2016, melvin6925 <melvin6...@gmail.com> wrote: You are correct, nothing has changed. This is a very simple request

Re: [GENERAL] strange sql behavior

2016-02-01 Thread melvin6925
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 4G LTE smartphone Original message From: Yu Nie <niey...@gmail.com> Date: 2/1/2016 15:01 (GMT-05:00) To: melvin6925 <melvin6...@

Re: [GENERAL] strange sql behavior

2016-02-01 Thread melvin6925
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 4G LTE smartphone Original message From: Bill Moran

Re: [GENERAL] temporary indexes?

2015-10-21 Thread melvin6925
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 4G LTE smartphone Original message From: Adrian Klaver

Re: [GENERAL] FW: Constraint exclusion in partitions

2015-05-23 Thread melvin6925
Did you remember to set  constraint_exclusion = on and reload the .conf ? Sent via the Samsung Galaxy S® 6, an ATT 4G LTE smartphone Original message From: Daniel Begin jfd...@hotmail.com Date: 05/23/2015 14:37 (GMT-05:00) To: pgsql-general@postgresql.org Subject: Re: