Re: how to setup postgres user

g that is incorrect? 'su - postgres' becomes the postgres user, so if you're an ordinary user at the time you run that you'll need postgres' password, which is probably disabled. Make sure to run 'su - postgres' while already root. -- Colin Watson

how to setup postgres user

hello all recently i added a beancounter package. when i run setup_beancounter, it says, no postgressql user 'sandip'. it also recommends me to su - postgres. when i do this, neither my root password nor my user password works! what am i doing that is incorrect? -- regards, sandip p deshmukh

Re: postgres user

Blake Barnett wrote: >Call me crazy, but I can't seem to get into the database anymore. The >postgres user didn't have a password before and it won't accept a blank >password anymore. The postgres user was the only user and so there's no way >to get in