Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Brodie S
As far as I can tell, It does not On Sat, Aug 23, 2014 at 5:15 PM, John R Pierce wrote: > On 8/23/2014 4:07 PM, Brodie S wrote: > >> I'm using Unraid and SMB >> >> > does the NAS box and your server support ISCSI so you can use your OS's > native file system? that's a much better choice. > > >

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread John R Pierce
On 8/23/2014 4:07 PM, Brodie S wrote: I'm using Unraid and SMB does the NAS box and your server support ISCSI so you can use your OS's native file system? that's a much better choice. -- john r pierce 37N 122W somewhere on the middle of the left coast

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Brodie S
I'm using Unraid and SMB On Fri, Aug 22, 2014 at 5:07 PM, John R Pierce wrote: > On 8/19/2014 11:03 AM, Brodie S wrote: > > I am installing the Data directory on a NAS server. > > > what NAS file sharing protocol? (choices include SMB/CIFS, AFP, NFS, and > probably others).Network file sh

Re: [GENERAL] How to insert either a value or the column default?

2014-08-23 Thread John McKown
Would you mind a non-python solution? I think the following will work for you. It uses an INSERT trigger on the table "tasks". The only minus is keeping the default value in both the table definition and the trigger. Of course, it is not really needed in the definition of the row value in the table

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Adrian Klaver
On 08/23/2014 11:09 AM, Brodie S wrote: How would that be done on a Mac? Well that was stupid of me, forgetting you where using the Mac installer. Not sure how to do that on Mac or if it is even possible. Best I can do is point you here: http://www.enterprisedb.com/docs/en/9.3/pginstguide/P

[GENERAL] How to insert either a value or the column default?

2014-08-23 Thread W. Matthew Wilson
I have a table that looks sort of like this: create table tasks ( task_id serial primary key, title text, status text not null default 'planned' ); In python, I have a function like this: def insert_task(title, status=None): and when status i

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Brodie S
How would that be done on a Mac? On Fri, Aug 22, 2014 at 5:51 PM, Adrian Klaver wrote: > On 08/22/2014 04:34 PM, Brodie S wrote: >> I have installed with the default data directory with success. Sadly, >> thats not an option for me > Hmmm, so the installer is basically working, just not to that

[GENERAL] AIX GCC

2014-08-23 Thread Anderson Valadares
Hello, we have a client with AIX version 7.1 what is using PostgreSQL 9.3.5 compiled with GCC 4.6.4 wonder if it's appropriate or would you rather use the XLC to obtain a better performance? Regards Anderson

Re: [GENERAL] Query planner question

2014-08-23 Thread Alban Hertroys
On 23 Aug 2014, at 4:34, Soni M wrote: > On Fri, Aug 22, 2014 at 9:10 PM, Alban Hertroys wrote: > On 22 August 2014 14:26, Soni M wrote: > > Currently we have only latest_transmission_id as FK, described here : > > TABLE "ticket" CONSTRAINT "fkcbe86b0c6ddac9e" FOREIGN KEY > > (latest_transmissio