[GENERAL] Why can't I change a password

2011-01-16 Thread Steve Litt
Hi all, I've somehow messed up something. psql super psql (8.4.5) Type help for help. super= \du+ List of roles Role name | Attributes | Member of | Description ---+-+---+- bobo | | {}| junk |

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Dmitriy Igrishin
Hey Steve, 2011/1/16 Steve Litt sl...@troubleshooters.com Hi all, I've somehow messed up something. psql super psql's synopsis is psql [option...] [dbname [username]] Thus, the call psql super connects psql to a database super but since username unspecified it is connected with

Re: [GENERAL] Why can't I change a password SOLVED

2011-01-16 Thread Steve Litt
Thanks Dmitriy, It turns out the solution I used was to su to postgres in Linux, and then run the command psql without arguments, at which time I could have my way with any object. More in my responses to you... On Sunday 16 January 2011 06:21:28 Dmitriy Igrishin wrote: Hey Steve,

Re: [GENERAL] Why can't I change a password SOLVED

2011-01-16 Thread Raymond O'Donnell
On 16/01/2011 20:56, Steve Litt wrote: Thanks Dmitriy, It turns out the solution I used was to su to postgres in Linux, and then run the command psql without arguments, at which time I could have my way with any object. More in my responses to you... On Sunday 16 January 2011 06:21:28 Dmitriy

Re: [GENERAL] Why can't I change a password SOLVED

2011-01-16 Thread Steve Litt
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: If you have configured PG to listen on a TCP/IP port (5432 by default), you can also do: psql -U postgres -h localhost super Ray. Thanks Ray, My psql seems a lot different from others. Loook what happened: slitt@mydesk:~$

Re: [GENERAL] Why can't I change a password SOLVED

2011-01-16 Thread Raymond O'Donnell
On 16/01/2011 21:39, Steve Litt wrote: On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: If you have configured PG to listen on a TCP/IP port (5432 by default), you can also do: psql -U postgres -h localhost super Ray. Thanks Ray, My psql seems a lot different from others.

Re: [GENERAL] Why can't I change a password SOLVED

2011-01-16 Thread Steve Litt
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: If you have configured PG to listen on a TCP/IP port (5432 by default), you can also do: psql -U postgres -h localhost super Ray. Thanks Ray, You were so close! The command that works is this: psql -U super -h localhost

Re: [GENERAL] Why can't I change a password SOLVED

2011-01-16 Thread Adrian Klaver
On Sunday 16 January 2011 1:49:43 pm Steve Litt wrote: On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: If you have configured PG to listen on a TCP/IP port (5432 by default), you can also do: psql -U postgres -h localhost super Ray. Thanks Ray, You were so

Re: [GENERAL] Why can't I change a password SOLVED

2011-01-16 Thread Adrian Klaver
On Sunday 16 January 2011 1:49:43 pm Steve Litt wrote: On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: If you have configured PG to listen on a TCP/IP port (5432 by default), you can also do: psql -U postgres -h localhost super Ray. Thanks Ray, You were so