database location path

[mnavahan]

Hi

i am firebird user and newbie in postgresql

the first problem od me is how set path od database file in create database (pg 8.3) ?

also when i have multiple database in one server (and different db path) how access each and set each database file ?

can show me command do it ?
also how done it in pgadmin when from remote try connect db ....

/mz

 

[feherke]

Hi

What you mean, "database file" ?

The database is composed by many files. Only the directory is specified when starting the server by the -D flag or by the value of [tt]PGDATA[/tt] environment variable.

Client applications should only know the socket where the server listens for connections.

I never used [tt]pgadmin[/tt] but as far as I know, it is just a simple client. In which case you have to specify only where to connect.

Feherke.

http://rootshell.be/~feherke/