From: | "Andres Ledesma" <aledes(at)telefonica(dot)net> |
---|---|
To: | "rx" <rong(dot)xie(at)stud(dot)tu-muenchen(dot)de> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [ADMIN] help me!! |
Date: | 2003-02-13 19:21:50 |
Message-ID: | 003901c2d395$29652ec0$02001aac@maradis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support pgsql-admin pgsql-docs pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | frank_lupo | 2003-02-14 09:05:38 | new export access |
Previous Message | frank_lupo | 2003-02-13 15:57:41 | RE: documentation from pgAdmin2 |
From | Date | Subject | |
---|---|---|---|
Next Message | Sutto Zoltan | 2003-02-14 12:42:48 | pgadmin-support@postgresql.org <pgadmin-support@postgresql.org> |
Previous Message | Jason Tishler | 2003-02-13 12:18:22 | Re: configure: error: no acceptable C compiler found in $PATH |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-02-13 19:31:21 | Re: postgresql mysql max connections |
Previous Message | Oliver Elphick | 2003-02-13 17:58:02 | Re: Database backup |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-02-14 01:14:46 | Re: Links to the FAQs at PostgreSQL.org |
Previous Message | Florian Wunderlich | 2003-02-13 16:27:21 | Re: Bug #866 related problem (ATTN Tom Lane) |
From | Date | Subject | |
---|---|---|---|
Next Message | Emmanuel Charpentier | 2003-02-13 19:32:36 | Aggregates with non-commutative transition functions |
Previous Message | Andres Ledesma | 2003-02-13 19:18:37 | Re: How to create stored procedure in PostgreSQL? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-02-13 19:22:18 | Re: [HACKERS] Changing the default configuration |
Previous Message | Bruce Momjian | 2003-02-13 19:17:51 | Re: location of the configuration files |