X-Original-To: pgsql-general@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D381D475DAD for ; Thu, 13 Feb 2003 14:25:34 -0500 (EST) Received: from tnetsmtp2.mail.isp (stress.telefonica.net [213.4.129.135]) by postgresql.org (Postfix) with ESMTP id 9AB94475E31 for ; Thu, 13 Feb 2003 14:25:04 -0500 (EST) Received: from maradis ([217.127.98.52]) by tnetsmtp2.mail.isp (terra.es) with ESMTP id HA9HXR00.OIF; Thu, 13 Feb 2003 20:25:03 +0100 Message-ID: <003901c2d395$29652ec0$02001aac@maradis> From: "Andres Ledesma" To: "rx" Cc: References: <000801c2d283$564c39a0$d2e0f48a@ips64m> <000f01c2d2e4$a8cae1c0$02001aac@maradis> <002901c2d360$8c5cac40$16e1f48a@IPSM7N> Subject: Re: [ADMIN] help me!! Date: Thu, 13 Feb 2003 20:21:50 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0036_01C2D39D.8A8C4550" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/729 X-Sequence-Number: 37483 This is a multi-part message in MIME format. ------=_NextPart_000_0036_01C2D39D.8A8C4550 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi rong... well...is the postmaster running ?=20 there are a couple of postintallation steps ... first, you must create and prepare the data files. lets assume your pgSQL is installed on /usr/local/pgsql, right ?=20 1 . make dir where your data files are going to live, say data root# mkdir /usr/local/pgsql/data 2 . lets make user postgres the owner of this dir root# chown postgres /usr/local/pgsql/data=20=20=20=20 3 . let postgres init dababase on this dir root# su postgres postgres# /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data 4 . start the postmaster.. set the environment var PGDATA=3D/usr/local/pgsql/data postgres# /usr/local/pgsql/bin/postmaster -i -i allows tcp connections to the db.=20 5 .start the client=20 postgres# /usr/local/pgsql/bin/psql There is are various front end GUI's to postgres..one I use is pgAc= cess-- go to their page and lurk a bit ..=20 If you don't have the postgresql docs, you should take it on the postgres= ql.org site because there are a lot of options to postgresql be compiled wi= th depending on further use you are going to do..to conect via Java, C++..= . and any way...printing this docs you'll find most of your answers faster.= There are the admin, programmer, user...guides..and a small tutorial.. Good luck .. and best regards, Andrew ------=_NextPart_000_0036_01C2D39D.8A8C4550 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

hi rong...

well...is the postmaster running ? =

there are a couple of postintallation step= s=20 ...

first, you must create = and=20 prepare the data files.

lets assume your pgSQL = is=20 installed on /usr/local/pgsql, right ?

1 . make dir where your= data=20 files are going to live, say data

root# mkdir=20 /usr/local/pgsql/data

2 . lets make user post= gres the=20 owner of this dir

root# chown p= ostgres=20 /usr/local/pgsql/data

3 . let postgres i= nit=20 dababase on this dir

root= # su=20 postgres

postgres#=20 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

4 . start the=20 postmaster..

set = the=20 environment var PGDATA=3D/usr/local/pgsql/data

postgres#=20 /usr/local/pgsql/bin/postmaster -i

-i allows tcp connections = to=20 the db.

5 .start the client

postgres#=20 /usr/local/pgsql/bin/psql

There is are various front = end=20 GUI's to postgres..one I use is pgAccess-- go to their page and lurk a bit = ..=20

If you don't have the postgres= ql docs,=20 you should take it on the postgresql.org site because there are a lot of op= tions=20 to postgresql be compiled with depending on further use you are going to do= ..to=20 conect via Java, C++... and any way...printing this docs you'll = find=20 most of your answers faster. There are the admin, programmer, user...guides= ..and=20 a small tutorial..

Good luck .. and best regards,

Andrew

------=_NextPart_000_0036_01C2D39D.8A8C4550--