[plug] DebNewbie Q?
sol
solhanna at dingoblue.net.au
Fri Nov 9 16:59:44 WST 2001
Hi PLUGers,
I just wanted to say thankyou to Tony, Michael H, and Jeremy for the
Postgresql tips. I took all your advice, read the online info under the
"administrator's guide" at postgresql.org. I then decided to start
fresh, so I removed the postgres packages and reinstalled them. This
time I followed the online instructions carefully and checked that all
the processes were up and running before trying to createuser (this time
from su - postgres). It worked! At last I can get started!
Cheers,
And enjoy your weekend!
Sol
Anthony J. Breeds-Taurima wrote:
> On Tue, 6 Nov 2001, sol wrote:
>
>
>> Afternoon PLUGers,
>>
>> Following on some advice from one of the list gurus some time back I
>> decided to teach myself PostgreSQL. So I got the book "PostgreSQL:
>> Introduction and Concepts" by Bruce Momjian and installed Postgres and
>> excitedly began my first lesson. However, I got stymied straight up when
>> I tried to launch psql from the console by being told that I needed to
>> set user ID to "sol" for pg_shadow. I'd no idea how to do this, but
>> after a hunt through the man pages found suidregister (I thought that
>> this was the tool for the job) and did this:
>>
>> suidregister /var/lib/postgres/data/pg_shadow sol postgres 600
>
> reverse this.
>
> as root
> createuser -P sol
> answer yes to all the questions.
>
> This will creat you a postgres account. from there you should be pretty
> set to follow the book.
>
>
> Yours Tony.
>
> /*
> * "The significant problems we face cannot be solved at the
> * same level of thinking we were at when we created them."
> * --Albert Einstein
> */
>
>
>
More information about the plug
mailing list