You need to add a host entry to the pg_hba file from what I remember. I
don't think you want to share your database via NFS either but instead
use a single postmaster process on the system where the database files
physically reside. Since all client connections are done via TCP/IP
sockets, you can access your databases remotely over your network. I
think it's OK to use NFS for the purposes of having access to the
postgres utilities, libraries and such, but don't try to have a separate
postmaster process on each system trying to manage the database files as
I would expect the database files to become corrupted.
Tony
Wybo Dekker wrote:
>
> After successfully putting my 2 pc's in a network and starting up NFS,
> I would like to give pc2 access to the Postgress database on pc1.
> So I created the mount point /var/lib/pgsql on pc2 and mounted
> /var/lib/pgsql of pc1 on it.
>
> I was surprised to see that, looking from pc2, I could see all files
> down to /var/lib/pgsql/data/base but the files in the base directory
> seemed absent:
>
> On pc 1 I saw: | And on pc 2:
> |
> />ls /var/lib/pgsql/data/{.,base} | />ls /var/lib/pgsql/data/{.,base}
> /var/lib/pgsql/data/.: | /var/lib/pgsql/data/.:
> PG_VERSION pg_hba.conf | PG_VERSION pg_hba.conf
> base pg_log | base pg_log
> pg_database pg_pwd | pg_database pg_pwd
> pg_geqo.sample pg_shadow | pg_geqo.sample pg_shadow
> pg_group pg_variable | pg_group pg_variable
> |
> /var/lib/pgsql/data/base: | /var/lib/pgsql/data/base:
> template1 wybo | />
> /> |
>
> I could, nevertheless, connect to database 'wybo' on pc2, but I could
> not look in it:
>
> wybo@melati:~ > psql
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: wybo
>
> wybo=> \d
> NOTICE: AbortTransaction and not in in-progress state
> NOTICE: AbortTransaction and not in in-progress state
> wybo=>
>
> Is there a better way to do this?
>
> --
> Hartelijke groet, Wybo Dekker
> ___________________Servalys Analytical Chemistry Services__________________
> [EMAIL PROTECTED] | Deilsedijk 60 | tel +31-345-652164
> www.hobby.nl/~servalys | 4158 CH Deil, The Netherlands | fax +31-345-652383
> -
> To get out of this list, please send email to [EMAIL PROTECTED] with
> this text in its body: unsubscribe suse-linux-e
> Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the
> archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
--
[EMAIL PROTECTED]
-
To get out of this list, please send email to [EMAIL PROTECTED] with
this text in its body: unsubscribe suse-linux-e
Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the
archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
