Re: [GENERAL] Large pg_xlog

2016-09-28 Thread Michael Paquier
On Thu, Sep 29, 2016 at 2:25 PM, Francisco Reyes wrote: > There is no archive_status > > ll 9.3/main/pg_xlog/ |grep arch > postgres@s0pdb03:~$ Meh. There must be a folder named archive_status in pg_xlog. Or something is broken with your installation. Don't you have in your

Re: [GENERAL] Large pg_xlog

2016-09-28 Thread Francisco Reyes
On 09/26/2016 09:05 PM, Michael Paquier wrote: What are the files in pg_xlog/archive_status? Do see a lot of .ready entries? Perhaps you could de-bloat things by using archive_command = '/bin/true' (REM on Windows as far as I recall). There is no archive_status ll 9.3/main/pg_xlog/ |grep

Re: [GENERAL] Graphical entity relation model

2016-09-28 Thread Stephen Davies
On 29/09/16 05:47, jotpe wrote: Does anybody know a Software for generating graphical entity relation models from existing postgresql databases? Best regards Johannes I like SchemaSpy. -- = Stephen Davies Consulting

Re: [GENERAL] Graphical entity relation model

2016-09-28 Thread Mike Sofen
From: jotpe Sent: Wednesday, September 28, 2016 1:17 PM Does anybody know a Software for generating graphical entity relation models from existing postgresql databases? Best regards Johannes --- I don’t know any useful free ones, but my favorite less expensive one (and the one I’ve

[GENERAL] cluster on table rewrite

2016-09-28 Thread Jeff Janes
I need to add a new column to my largest table, something like: alter table foo add column col_15 text not null default 'foobar'; I am tempted to add the column as NULL, and then use coalesce and nullif in the client code to re-interpret NULL as being the value 'foobar'. But I think that that

Re: [GENERAL] Graphical entity relation model

2016-09-28 Thread Scott Mead
On Wed, Sep 28, 2016 at 4:17 PM, jotpe wrote: > Does anybody know a Software for generating graphical entity relation > models from existing postgresql databases? > > My personal favorites (in order): schemaspy.sf.net https://www.dbvis.com/ http://www.sqlpower.ca/page/architect

[GENERAL] Graphical entity relation model

2016-09-28 Thread jotpe
Does anybody know a Software for generating graphical entity relation models from existing postgresql databases? Best regards Johannes

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-28 Thread Kevin Grittner
On Tue, Sep 27, 2016 at 3:12 PM, dudedoe01 wrote: > The tables I migrated from MySQL into postgreSQL have exactly the same amount > of rows of data so the problem is inside the view being created. Have you actually confirmed that there are any cases where isnull(expression)

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-28 Thread Thomas Kellerer
dudedoe01 schrieb am 27.09.2016 um 19:04: > I am trying to emulate the isnull() function used in MySQL into postreSQL. I > have tried different ways such is null but it's not producing the results > desired. I am doing a data migration from MySQL into postgreSQL and need > help with the isnull()

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-28 Thread Adrian Klaver
On 09/27/2016 01:10 PM, dudedoe01 wrote: Thanks Kevin, Igor and Adrian. In MySQL with the isnull() function I get all three values RPG INV, Owner Inventory, and Builder Inventory showed up in the view while when I do the is null function in postgreSQL I only see Builder Inventory and Owner

Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-28 Thread Pavel Stehule
2016-09-28 14:34 GMT+02:00 Mike Sofen : > *From:* Pavel Stehule*Sent:* Tuesday, September 27, 2016 9:18 PM > 2016-09-28 6:13 GMT+02:00 Pavel Stehule : > > Hi > > 2016-09-27 23:03 GMT+02:00 Mike Sofen : > > Hi gang, > > how to view

Re: [GENERAL] Database fixed size

2016-09-28 Thread Adir Shaban
So how did heroku limit the database size per user? I thought about creating triggers on insert and updates but that will lead to bad performance On Wed, Sep 28, 2016, 15:31 Tom Lane wrote: > Albe Laurenz writes: > > Adir Shaban wrote: > >> Is there

Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-28 Thread Mike Sofen
From: Pavel StehuleSent: Tuesday, September 27, 2016 9:18 PM 2016-09-28 6:13 GMT+02:00 Pavel Stehule >: Hi 2016-09-27 23:03 GMT+02:00 Mike Sofen >: Hi gang, how to view the state of a

Re: [GENERAL] Database fixed size

2016-09-28 Thread Tom Lane
Albe Laurenz writes: > Adir Shaban wrote: >> Is there anyway to limit a database size? >> For example, I need to create a database for user X and I don't want it to >> use more than 5 GB. > You can create a tablespace on a device with limited size. > Then you can create

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-28 Thread Alexander Farber
Maybe your are after IS NOT DISTINCT FROM NULL https://www.postgresql.org/docs/current/static/functions-comparison.html

Re: [GENERAL] Database fixed size

2016-09-28 Thread Albe Laurenz
Adir Shaban wrote: > Is there anyway to limit a database size? > For example, I need to create a database for user X and I don't want it to > use more than 5 GB. You can create a tablespace on a device with limited size. Then you can create the database on that tablespace. Yours, Laurenz Albe

Re: [GENERAL] Database fixed size

2016-09-28 Thread amul sul
On Wed, Sep 28, 2016 at 1:39 PM, Adir Shaban wrote: > Hey, > > Is there anyway to limit a database size? Nope. check this https://www.postgresql.org/message-id/619537.42270.qm%40web53708.mail.re2.yahoo.com thread. Regards, Amul -- Sent via pgsql-general mailing list

[GENERAL] Database fixed size

2016-09-28 Thread Adir Shaban
Hey, Is there anyway to limit a database size? For example, I need to create a database for user X and I don't want it to use more than 5 GB.