public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andres Ledesma <[email protected]>
To: rx <[email protected]>
Cc: [email protected]
Subject: Re: [ADMIN] help me!!
Date: Thu, 13 Feb 2003 20:21:50 +0100
Message-ID: <003901c2d395$29652ec0$02001aac@maradis> (raw)
References: <000801c2d283$564c39a0$d2e0f48a@ips64m>
	<000f01c2d2e4$a8cae1c0$02001aac@maradis>
	<002901c2d360$8c5cac40$16e1f48a@IPSM7N>

hi rong...

well...is the postmaster running ? 

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 ? 

    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    

    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=/usr/local/pgsql/data
        postgres# /usr/local/pgsql/bin/postmaster -i

        -i allows tcp  connections to the db. 

    5 .start the client 
        postgres# /usr/local/pgsql/bin/psql

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

  If you don't have the postgresql docs, you should take it on the postgresql.org site because there are a lot of options to postgresql be compiled with 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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: [ADMIN] help me!!
  In-Reply-To: <003901c2d395$29652ec0$02001aac@maradis>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox