Re: [GENERAL] [newbie] server startup

2005-08-23 Thread Mark Probert
Hi .. On Tue, 2005-08-23 at 14:45 -0700, Mark Probert wrote: > > SO, the db is up and running locally but I can't get to it from the > network. > With a friend's help, I worked out that I need to edit two files: postgresql.conf (listen_address = '*') pg_

[GENERAL] [newbie] server startup

2005-08-23 Thread Mark Probert
Hi .. I am just playing with PostgreSQL 8.0.1 The server is running on a Solaris 8 platform with the kernel parameters tweaked as suggested. When I start the server, the logfile reports: $ pg_ctl start -l logfile postmaster starting $ cat logfile LOG: could not bind

[GENERAL] drop table before create

2005-08-23 Thread Mark Probert
Hi .. I have not been able to work out how to do this is Postgres 8 (pseudo-code) if exists table foo drop table foo; end create table foo; If I go with drop table foo; create table foo; then it barfs on an empty db. I can find the table name in pg_class but I am not sure of where t