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

On Sat, Apr 23, 2016 at 3:17 PM, Melvin Davidson wrote: > > On Sat, Apr 23, 2016 at 1:03 AM, Shulgin, Oleksandr < > oleksandr.shul...@zalando.de> wrote: > >I find yor lack of proper email quoting skills disturbing.. > > I am sorry you are disturbed, but thank you fo

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

On Apr 22, 2016 19:46, "Melvin Davidson" wrote: > > > First, tahnk you for your feedback Alex. > > "IMO, every time it was conclusively demonstrated that when you consider dump/restore semantics, this feature can have exactly zero value if implemented *inside pg_catalog*. And it would have to be

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

On Thu, Apr 21, 2016 at 6:55 PM, Melvin Davidson wrote: > And so far, NO ONE has shown any proof that this enhancement could > possibly cause ANY negative result. > Searching through the list archives[1] I can see that you've asked this question a number of times already. And I'm pretty sure it

Re: [GENERAL] Enhancement Request

On Wed, Apr 20, 2016 at 3:47 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Apr 19, 2016 at 5:59 PM, Melvin Davidson > wrote: > >> >> Enhancement or feature requests should probably go to *Custormer >> Feedback * >> htt

Re: [GENERAL] how to switch old replication Master to new Standby after promoting old Standby

On Mon, Mar 14, 2016 at 6:28 PM, John Lumby wrote: > > From: johnlu...@hotmail.com > To: pgsql-general-ow...@postgresql.org > Subject: how to switch old replication Master to new Standby after > promoting old Standby > Date: Mon, 14 Mar 2016 13:23:29 -0400 > > In a scenario involving replication

Re: [GENERAL] pg_restore real file size

On Fri, Feb 26, 2016 at 5:30 AM, John R Pierce wrote: > On 2/25/2016 8:26 PM, drum.lu...@gmail.com wrote: > > > I'm doing the pg_restore now in a 1.5TB file: > > *# ls -la* > > postgres postgres 1575324616939 Feb 20 13:55 devdb_0.sql > > But, the restore has gone over 1.6 TB > > > the dump file d

Re: [GENERAL] sslcompression / PGSSLCOMPRESSION not behaving as documented?

On Thu, Feb 18, 2016 at 11:37 PM, Jeff Janes wrote: > On Fri, Jan 16, 2015 at 10:34 AM, Maciek Sakrejda > wrote: > > Thanks, everyone. That seems to be it. I still haven't gotten it to work > (I > > tried setting OPENSSL_DEFAULT_ZLIB=true in > > /etc/postgresql/9.2/main/environment and restartin

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

On Tue, Jan 26, 2016 at 4:21 PM, Edson F. Lidorio wrote: > > > On 25-01-2016 16:46, Igal @ Lucee.org wrote: > > Hi Everybody, > > I have posted a video tutorial on How to Compile PostgreSQL 9.5 for > Windows 64bit > https://www.youtube.com/watch?v=-BJmuZT5IPE > > It was quite difficult for me to

Re: [GENERAL] help:error while running postgres after installing postgresql server from source code

On Sat, Jan 23, 2016 at 6:42 PM, Shubham Barai wrote: > > I was trying to install postgresql from source code on ubuntu.I followed all the instructions and installed all the packages.I was also able to create database cluster but when I executed this command 'postgres -D /usr/local/pgsql/data' I g

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

On Fri, Jan 15, 2016 at 3:41 PM, Andreas Joseph Krogh wrote: > På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr < > oleksandr.shul...@zalando.de>: > > On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh > wrote: >> >> >> I see that wal_l

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh wrote: > På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby < > jim.na...@bluetreble.com>: > > On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote: > > Where can I find more info about how to use and configure pg_logical to > > replicate a 9.

Re: [GENERAL] [BUGS] permissions.

[not a bug, moving to -general] On Tue, Jan 12, 2016 at 12:46 PM, Frik Brits wrote: > Hello, > What is to be done here, below between the lines is an excerpt from my > bash console if I want to start PostgreSQL. > > > --

Re: [GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

On Tue, Jan 12, 2016 at 10:28 AM, Dev Kumkar wrote: > > Hello, > > > I want to upgrade my database from version 9.3.4 to 9.3.10. > > For this task, do I need to upgrade database using pg_upgrade utility? > http://www.postgresql.org/docs/9.3/static/pgupgrade.html > > > From the details it looks lik

Re: [GENERAL] [BUGS] postgresql table data control

On Sat, Oct 17, 2015 at 1:26 AM, 許耀彰 wrote: > Dear Support Team, > How can we know each table data increase day by day? It mean how do we get > how many data produce today,included which data? Thank you. > [moving from bugs@] Please refer to these SQL-level functions: pg_relation_size() pg_tot