[plug] DebNewbie Q?

Anthony J. Breeds-Taurima tony at cantech.net.au
Tue Nov 6 17:21:28 WST 2001


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