Re: [GENERAL] Query with error - DOW FROM timestamp

2014-05-25 Thread Victor Sterpu
Yes, thank you. -- Original Message -- From: "Albe Laurenz" To: "Victor Sterpu" ; "PostgreSQL General" Sent: 5/23/2014 12:51:30 PM Subject: RE: [GENERAL] Query with error - DOW FROM timestamp Victor Sterpu wrote: When I run the query from down I receive an error. How can I write

[GENERAL] Trouble running nested select - Join query

2014-05-25 Thread RUSHI KAW
Hi, I have been working with Postgresxc 1.1 on a cluster, each cluster compute node having 48GB RAM. I have instantiated the coordinator on one of the compute nodes and have 4 datanodes (2+2) running on two other compute nodes.  I have been trying to run the  following query which is a select on

Re: [GENERAL] Shared memory changes in 9.4?

2014-05-25 Thread Tom Lane
Maciek Sakrejda writes: > I've been trying to take the 9.4 beta for a spin, but seem to have run into > a shared memory issue on startup: > FATAL: could not open shared memory segment "/PostgreSQL.1804289383": > Permission denied > We're running Postgres inside LXC, which I suspect is causing pr

[GENERAL] Shared memory changes in 9.4?

2014-05-25 Thread Maciek Sakrejda
Hi, I've been trying to take the 9.4 beta for a spin, but seem to have run into a shared memory issue on startup: FATAL: could not open shared memory segment "/PostgreSQL.1804289383": Permission denied We're running Postgres inside LXC, which I suspect is causing problems here, but 9.0 through 9