Re: [ADMIN] problem with initdb

1998-06-02 Thread The Hermit Hacker
On Tue, 2 Jun 1998, Tan Poh Soon wrote: > > > When i run the initdb, the following message shown: > > > We are initializing the database system with username pstan (uid=501). > > This user will own all the files and must also own the server process. > > > initdb: creating template da

[ADMIN] problem with initdb

1998-06-02 Thread Tan Poh Soon
When i run the initdb, the following message shown: We are initializing the database system with username pstan (uid=501). This user will own all the files and must also own the server process. initdb: creating template database ini /usr/local/pgsql/data/base/template1 Running: postgres -boot -C

Re: [ADMIN] postgresql questions

1998-06-02 Thread Mateus Cordeiro Inssa
Hi, I have this problem: when I send a "vacuum" I get this error: NOTICE: Ind pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (962) IS NOT THE SAME AS HEAP' (961) FATAL 1: btree: cannot split if start (2) >= maxoff (2) That line with FATAL is showed also when I add a function (usualy with

[ADMIN] Running on different host

1998-06-02 Thread Andrey Novikov
Hello. How can I connect from Web to PostgreSQL running on another host? What do I need to set in PostgreSQL configuration? I'm using p5-Pg to access in on localhost. Thet's the initialization part (Perl): use Pg; $conn = Pg::connectdb("dbname = somedb user = someuser port=5432"); How do I add

Re: [ADMIN] postgresql questions

1998-06-02 Thread The Hermit Hacker
On Tue, 2 Jun 1998, Chan Fook Sheng wrote: > 4) when I run "psql template1 " or "createdb test" I get the following: > > connection to database 'template1' failed. > PQexec() -- Request was sent to backend, but backend closed the channel > before responding. This probably means the backend termi

[ADMIN] postgresql questions

1998-06-02 Thread Chan Fook Sheng
Hello everybody, I have some questions on Postgresql, pls help me if you can. I have installed postgresql 6.2.1on FreeBSD 2.2.6. To start it, I must first start the postmaster running, so I : 1) su pgsql (this account I think was created during the installation) 2) postmaster (I get this messa