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
