Re: [GENERAL] pg_upgrade & tablespaces

2013-12-22 Thread Joseph Kregloh
> [root@postgres-93-upgrade /usr/local/pgsql/data/drupal_dbspace]# ls -la >> /home/jkregloh/pg_data/data/drupal_dbspace/ >> drwx-- 4 pgsql pgsql 4 Oct 20 2011 PG_9.0_201008051 >> > > So that looks like it worked, or am I missing something. > Yes, it works but once it gets to the step whe

[GENERAL] Unix domain socket inconsistency

2013-12-22 Thread Thom Brown
Hi all, I'm a bit confused by my development set up. I can connect to PostgreSQL using unix domain sockets by not specifying any host with psql, and the same applies to vacuumdb, createdb and dropdb. However, when I go to use pgbench, it seems to be looking in the wrong place for the domain sock

Re: [GENERAL] Unix domain socket inconsistency

2013-12-22 Thread Adrian Klaver
On 12/22/2013 04:51 PM, Thom Brown wrote: PostgreSQL using unix domain sockets by not specifying any host with psql, and the same applies to vacuumdb, createdb and dropdb. However, when I go to use pgbench, it seems to be looking in the wrong place for the domain socket: thom@swift ~/Developme

Re: [GENERAL] Unix domain socket inconsistency

2013-12-22 Thread Thom Brown
On 23 December 2013 01:13, Adrian Klaver wrote: > On 12/22/2013 04:51 PM, Thom Brown wrote: > >> PostgreSQL using unix domain sockets by not specifying any host with >> psql, and the same applies to vacuumdb, createdb and dropdb. However, >> when I go to use pgbench, it seems to be looking in the

Re: [GENERAL] Unix domain socket inconsistency

2013-12-22 Thread Thom Brown
On 23 December 2013 01:15, Thom Brown wrote: > On 23 December 2013 01:13, Adrian Klaver wrote: >> On 12/22/2013 04:51 PM, Thom Brown wrote: >> >>> PostgreSQL using unix domain sockets by not specifying any host with >>> psql, and the same applies to vacuumdb, createdb and dropdb. However, >>> wh

Re: [GENERAL] Unix domain socket inconsistency

2013-12-22 Thread Adrian Klaver
On 12/22/2013 05:21 PM, Thom Brown wrote: On 23 December 2013 01:15, Thom Brown wrote: On 23 December 2013 01:13, Adrian Klaver wrote: On 12/22/2013 04:51 PM, Thom Brown wrote: I should have mentioned that I've checked that: thom@swift ~/Development $ which psql pgbench /home/thom/Develop

Re: [GENERAL] Unix domain socket inconsistency

2013-12-22 Thread John R Pierce
On 12/22/2013 5:21 PM, Thom Brown wrote: Hmm... now this is odd. I went to correct the PATH information in my .bashrc script file (to remove the superfluous trailing forward-slash), and when running both psql and pgbench in a new terminal, all is fine: fyi, I was going to suggest ther'es more

Re: [GENERAL] index and table corruption

2013-12-22 Thread Anand Kumar, Karthik
> >Thanks Shaun! > >Yes, we're getting synchronous_commit on right now. > >The log_min_duration was briefly set to 0 at the time I sent out the post, >just to see what statements were logged right before everything went to >hell. Didn't yield much since we very quickly realized we couldn't cope >wi