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,