Re: [GENERAL] dropdb weirdness

2010-06-30 Thread Steve Grey
Silly ideas, but is dropdb confusing the postgres user on the host and a database named postgres? (does the 1st database the command was run on still exist?) Does it do it right if the -U and -W switches are used? Steve On 29 June 2010 22:38, Geoffrey li...@serioustechnology.com wrote: Tom

[GENERAL] dropdb weirdness

2010-06-29 Thread Geoffrey
So running the following command: dropdb -p 5443 swr I get: dropdb: could not connect to database postgres: FATAL: database postgres does not exist Why is it not 'seeing' the database name I'm passing to it? Why is it trying to drop a database named postgres?? -- Until later, Geoffrey

Re: [GENERAL] dropdb weirdness

2010-06-29 Thread Merlin Moncure
On Tue, Jun 29, 2010 at 4:04 PM, Geoffrey li...@serioustechnology.com wrote: So running the following command: dropdb -p 5443 swr I get: dropdb: could not connect to database postgres: FATAL:  database postgres does not exist Why is it not 'seeing' the database name I'm passing to it?  

Re: [GENERAL] dropdb weirdness

2010-06-29 Thread Adrian Klaver
On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote: So running the following command: dropdb -p 5443 swr I get: dropdb: could not connect to database postgres: FATAL: database postgres does not exist Why is it not 'seeing' the database name I'm passing to it? Why is it trying to drop a

Re: [GENERAL] dropdb weirdness

2010-06-29 Thread Tom Lane
Adrian Klaver adrian.kla...@gmail.com writes: On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote: dropdb: could not connect to database postgres: FATAL: database postgres does not exist Why is it not 'seeing' the database name I'm passing to it? Why is it trying to drop a database named

Re: [GENERAL] dropdb weirdness

2010-06-29 Thread Geoffrey
Tom Lane wrote: Adrian Klaver adrian.kla...@gmail.com writes: On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote: dropdb: could not connect to database postgres: FATAL: database postgres does not exist Why is it not 'seeing' the database name I'm passing to it? Why is it trying to drop a