Re: [GENERAL] Download PostgreSQL 9.5 Alpha

Hello I also could not find the download on EDB. For Ubuntu 9.5 alpha is available but I was not able to install it using apt-get because it cannot resolve some dependencies. Finally I downloaded and compiled the source code. This worked well, but I had to do some additional steps to get the c

[GENERAL] return jsonb without field label

have tables with : create table mydocs (id serial primary key, data jsonb) when I do a select data from mydocs it comes back as {data: {my jsonb fields}} which then gets passed into a template - don't want to have to keep using <%= article.data.name %> instead of just data.name probably e

Re: [GENERAL] Download PostgreSQL 9.5 Alpha

On 07/03/2015 04:32 PM, Edson F. Lidorio wrote: Hello, PostgreSQL 9.5 Alpha not appear on the downloads list in [1] Where do I download for Windows? [1] http://www.enterprisedb.com/products-services-training/pgdownload#windows For those in the community who may not know, EnterpriseDB hosts

[GENERAL] Download PostgreSQL 9.5 Alpha

Hello, PostgreSQL 9.5 Alpha not appear on the downloads list in [1] Where do I download for Windows? [1] http://www.enterprisedb.com/products-services-training/pgdownload#windows -- Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

[GENERAL] PostgreSQL & VMWare

Hi, I work on a project that collects geolocalized data. All data will be in PostgreSQL / PostGIS. The small PostgreSQL databases will be on Linux guests on VMWare hosts. The size of the main database will grow by 50 TB / year, 500 M row / day. For the largest one, we plan to test different opti

Re: [GENERAL] database-level lockdown

Wouldn't it be easier just to prevent connections to the database while your transaction is executed? EG: UPDATE pg_database SET datallowconn FALSE WHERE datname = 'your_database' ; START TRANSACTION; COMMIT; UPDATE pg_database SET datallowconn TRUE WHERE datname = 'your_database' ; O

Re: [GENERAL] database-level lockdown

So, as database level locks do not exist (as per https://wiki.postgresql.org/wiki/Lock_database), I've thought of having a function that would lock *every* table in the database (far from the same, but would probably work for me). Something like: CREATE OR REPLACE FUNCTION lockdown() RETUR

Re: [GENERAL] Unusual sorting requirement (mixed enum/non-enum) - need thoughts

On Fri, Jul 3, 2015 at 11:27 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > CREATE TYPE enum_type AS ENUM ('X-One','A-Two'); > > SELECT * > FROM (VALUES > ('Not Enum'::text, 1::int, 'Uno'::text), > ('Not Enum', 2, 'Dos'), > ('Enum', 4, 'X-One'), > ('Enum', 3, 'A-Two')) val (flag, id,

[GENERAL] Unusual sorting requirement (mixed enum/non-enum) - need thoughts

CREATE TYPE enum_type AS ENUM ('X-One','A-Two'); SELECT * FROM (VALUES ('Not Enum'::text, 1::int, 'Uno'::text), ('Not Enum', 2, 'Dos'), ('Enum', 4, 'X-One'), ('Enum', 3, 'A-Two')) val (flag, id, val) ; I need to write an ORDER BY clause that will result in the output of: 1, 2, 4, 3 Basically, if

Re: [GENERAL] max number of locks

On 07/03/2015 03:14 AM, Fabio Pardi wrote: Hi, while experimenting with number of locks, i found something I cannot understand. From what i can read in the documentation, at any one given time, a query can obtain a max number of locks given by max_locks_per_transaction * (max_connections + m

Re: [GENERAL] Fwd: PostgreSQL & VMWare

Hi, It is slower in default settings of vmware environment. But today vmware has invented other things like SSD cache, vsan etc. If you can afford that kind of i/o improvments in your environment, it is very reasonable to continue on vmware, especially due to the ha things. 2015-07-03 14:37 GMT+0

Re: [GENERAL] Backup Method

På fredag 03. juli 2015 kl. 11:59:49, skrev howardn...@selestial.com < howardn...@selestial.com >: Hi everyone, I am reaching the point with my database backups where the backups are taking too long, and starting to interfere with running of the system during th

Re: [GENERAL] Backup Method

On 03/07/2015 12:23, Bill Moran wrote: On Fri, 03 Jul 2015 13:16:02 +0200 Jan Lentfer wrote: Am 2015-07-03 13:00, schrieb howardn...@selestial.com: On 03/07/2015 11:39, Guillaume Lelarge wrote: In that case is there any recommendation for how often to make base backups in relation to the

Re: [GENERAL] Fwd: PostgreSQL & VMWare

På fredag 03. juli 2015 kl. 12:35:07, skrev Jean-Gérard Pailloncy < jg.paillo...@adnow.fr >: Hi, I work on a project that collects geolocalized data. All data will be in PostgreSQL / PostGIS. The small PostgreSQL databases will be on Linux guests on VMWare hosts.

Re: [GENERAL] Backup Method

On Fri, 03 Jul 2015 13:16:02 +0200 Jan Lentfer wrote: > Am 2015-07-03 13:00, schrieb howardn...@selestial.com: > > On 03/07/2015 11:39, Guillaume Lelarge wrote: > >> > >> > In that case is there any recommendation for how often to make > >> base backups in relation to the size of the cluster and

Re: [GENERAL] Fwd: PostgreSQL & VMWare

On Fri, 3 Jul 2015 12:35:07 +0200 Jean-Gérard Pailloncy wrote: > > I work on a project that collects geolocalized data. > All data will be in PostgreSQL / PostGIS. > > The small PostgreSQL databases will be on Linux guests on VMWare hosts. > > The size of the main database will grow by 50 TB /

Re: [GENERAL] Backup Method

Am 2015-07-03 13:00, schrieb howardn...@selestial.com: On 03/07/2015 11:39, Guillaume Lelarge wrote: > In that case is there any recommendation for how often to make base backups in relation to the size of the cluster and the size of the WAL? > Nope, not really. That depends on a lot of thi

Re: [GENERAL] Backup Method

On 03/07/2015 11:39, Guillaume Lelarge wrote: > In that case is there any recommendation for how often to make base backups in relation to the size of the cluster and the size of the WAL? > Nope, not really. That depends on a lot of things. Our customers usually do one per day. -- Guilla

Re: [GENERAL] Backup Method

Le 3 juil. 2015 12:31 PM, "howardn...@selestial.com" < howardn...@selestial.com> a écrit : > > > > On 03/07/2015 11:15, Guillaume Lelarge wrote: >> >> >> pg_dumpall is not more efficient than pg_dump. As far as I can tell, you're looking for PITR backups. >> > > Thanks Guillame. > > In that case is

[GENERAL] Fwd: PostgreSQL & VMWare

Hi, I work on a project that collects geolocalized data. All data will be in PostgreSQL / PostGIS. The small PostgreSQL databases will be on Linux guests on VMWare hosts. The size of the main database will grow by 50 TB / year, 500 M row / day. For the largest one, we plan to test different opti

Re: [GENERAL] Backup Method

On 03/07/2015 11:15, Guillaume Lelarge wrote: pg_dumpall is not more efficient than pg_dump. As far as I can tell, you're looking for PITR backups. Thanks Guillame. In that case is there any recommendation for how often to make base backups in relation to the size of the cluster and the

Re: [GENERAL] Backup Method

Le 3 juil. 2015 12:03 PM, "howardn...@selestial.com" < howardn...@selestial.com> a écrit : > > Hi everyone, > > I am reaching the point with my database backups where the backups are taking too long, and starting to interfere with running of the system during the day. So I am looking for a bit of s

[GENERAL] max number of locks

Hi, while experimenting with number of locks, i found something I cannot understand. >From what i can read in the documentation, at any one given time, a query can >obtain a max number of locks given by max_locks_per_transaction * (max_connections + max_prepared_transactions) I then changed m

[GENERAL] Backup Method

Hi everyone, I am reaching the point with my database backups where the backups are taking too long, and starting to interfere with running of the system during the day. So I am looking for a bit of sage advice as to how to proceed. For a typical server, I have a single database cluster with

Re: [GENERAL] Slow index performance

You are right ... How embarrassing ... Why did I not see this? I will change the index and check again. I guess that the problem should be fixed then. Thanks a lot! Christian Deriva GmbH Financial IT and Consulting Christian Schröder G