dbTalk Databases Forums  

Re: install

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Re: install in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Aarni Ruuhimäki
 
Posts: n/a

Default Re: install - 01-04-2004 , 03:22 PM






Hulou,

First, you will have to run initdb (as user postgres perhaps):

#initdb -D /path/to/datadir/(owned by by postgres) -E (for encoding, perhaps
LATIN1 for umlauts and other funny characters to work and sort) -L
/default/onRH7.3/is/usr/local/pgsql/share/or/where/ever/postgres.bki/resides/

e.g:

initdb -D /usr/share/pgdata/ -E LATIN1 -L /usr/local/pgsql/share/

This will create your system / cluster.

Then, again as postgres or preferred user, or by default, start postmaster:

#/usr/local/pgsql/bin/postmaster -D /path/to/datadir/ -i(for port 5432 from
outside ?) -B (number of buffers) -N (number of connections allowed)

e.g.:

#/usr/local/pgsql/bin/postmaster -D /usr/share/pgdata/ -i -B 128 -N 256

Hope this helps. Please swim for your smile through the docs ...

Creating users on your system is maybe beyond this list but have a look at:

http://www.trustix.net/pub/Trustix/r...c/tsl-doc.html

It pretty much has it all. Next, start package-hunting to satisfy the various
depencies ... and good luck !

BR,

Aarni




On Thursday 01 January 2004 21:23, you wrote:
Quote:
Hi
I am a novice in using postgresql and I've faced to a
problem at the beginning of my work....

I have Linux OS on my computer and it has postgresql
server but I cant use it...whenever I want to make a
table
it says that "it can not connect to the server" and it
seems it's because no user has an ID on this server...
how can I make my server work?

thnx in advance

Novice....




__________________________________
Do you Yahoo!?
No. I Yippee.


Quote:
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com
-------------------------------------------------
This is a bugfree broadcast to you from a linux system.
-------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.