Re: Re: connecting to port tom

On Sunday 01 December 2002 20:01, hodges(at)xprt(dot)net wrote:
> When I access my database, tom, from Mozilla I get a
> message asking if postmaster is listening on port tom.
>
> I did a pg-dump and noticed one of the first lines is
> /connect - tom
>
> I suppose this is the database name rather than the port?

No, Connect as user tom, its a multi user database to reconsruct the database
correctly \connect ensures that its correctly connected as tom.
If you have some security settings swiched on the rebuild may fail unless you
do it as postgres.
I'm still trying to work out if its possible to dump a database without the
\connect s and grants so that when I rebuild it else where everything still
works properly (like at home where I don't have a user rob (or what ever)...)

Peter Childs

>
> Is there someplace I might be setting the port to "tom"?
> I am using the php_lib_login_include package - it worked
> fine before I moved to RedHat 8.
>
> Thanks
> Tom Hodges
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org