Re: Starting with postgreSQL and pgaccess

2001-07-23 Thread Oliver Elphick
Victor wrote: >Now the problem of this absolute beginner is the definition of ID when >using createuser. What exactly should I input at the prompt for it? My >user ID as a linux user (the one I find in records in file >/etc/passwd) or what else? This is an arbitrary identifier that defaul

Re: Starting with postgreSQL and pgaccess

2001-07-23 Thread Oliver Elphick
Joost Kooij wrote: >On Tue, Jul 17, 2001 at 04:30:57PM +, Victor wrote: >> I'm in trouble using pgaccess. After trying to >> open the same db giving its name and postgres as user it invariably >> answers: >> >> Connection to database failed ConnectDB().Conn

Re: Starting with postgreSQL and pgaccess

2001-07-18 Thread Joost Kooij
On Wed, Jul 18, 2001 at 03:09:20PM +, Victor wrote: > Joost Kooij [debian-user] <17/07/01 21:55 +0200>: > >Just create a valid user with your id, grant priviledges > > to create new databases and then after that you can do most or all things > > as regular user. > > First of all, thanks

Re: Starting with postgreSQL and pgaccess

2001-07-18 Thread Victor
Joost Kooij [debian-user] <17/07/01 21:55 +0200>: >Just create a valid user with your id, grant priviledges > to create new databases and then after that you can do most or all things > as regular user. First of all, thanks Joost, it now works for the postgres superuser only, not for other

Re: Starting with postgreSQL and pgaccess

2001-07-17 Thread Eric G. Miller
On Tue, Jul 17, 2001 at 04:30:57PM +, Victor wrote: > Connection to database failed ConnectDB().Connection refused: Is > the postmaster running (with -i) at localhost and accepting > connections on TCP/IP port 5432? Probably postgresql is not listening for tcp/ip connections. If I remembe

Re: Starting with postgreSQL and pgaccess

2001-07-17 Thread Joost Kooij
On Tue, Jul 17, 2001 at 04:30:57PM +, Victor wrote: > I'm now having a go at using postgresql, the version included in debian > 2.2r3. > > Now, while I've been able to create my first db and tables using psql > under postgres user, No need for that. Just create a valid user with your id,

Starting with postgreSQL and pgaccess

2001-07-17 Thread Victor
I'm now having a go at using postgresql, the version included in debian 2.2r3. Now, while I've been able to create my first db and tables using psql under postgres user, I'm in trouble using pgaccess. After trying to open the same db giving its name and postgres as user it invariably answers: Co