psql \connect db@host.ip.address.here -- no more
to connect to a remote postgresql server, we can use psql thus:
psql -h 192.168.1.2 distantdbname
with psql v7.0.3 i could be INSIDE psql already and do
somedb=# \c anotherdb
anotherdb=# \c remotedb@192.168.1.2
remotedb=# \d
but with 7.1 i get
somedb=# \c anotherdb
anotherdb=# \c remotedb@192.168.1.2
FATAL 1: Database "remotedb@192.168.1.2" does not exist in the system catalog.
Previous connection kept
anotherdb=# \q
is there a fix i missed?
--
I'd concentrate on "living in the now" because it is fun
and on building a better world because it is possible.
- Tod Steward
will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
Reply to: