Question regarding authentication/login - Mailing list pgsql-general

From Chris Deadlock
Subject Question regarding authentication/login
Date
Msg-id CAHx9JKbXkEtZUYLTtJcC=3VvkP2zzUz-_dhY_07BnG-Qs9GigA@mail.gmail.com
Whole thread Raw
Responses Re: Question regarding authentication/login
Re: Question regarding authentication/login
List pgsql-general
Hello, I have installed postgres version 8.4.9 from the debian repository.

I set up a username and password, and was able to create my tables and add information to the database from a java application running through a remote SSH tunnel.

Then I moved this same command line program onto the same server as the database resides : when I create tables from this location I can only access them from this local machine: I can use psql -U user dbname (same login and pass as the remote connection)   and i can    select * from users;      and it shows all the entries just fine.

But if I try to connect using the same login and password through a remote SSH tunnel, I can not see any of the tables created from the CLI on the server...  If I create the tables from the remote location I can query them fine.

The exact error message is : ERROR: relation "users" does not exist  (Either from pgAdmin GUI, or from the command line interface that comes with pgAdmin )

Am I misunderstanding something fundamental about user authentication? How does postgres distinguish localhost connections from SSH tunneled connections? Is it possible that somehow connecting form a local linux-user account is creating hidden tables within my otherwise remotely accessable database?

Thank you


pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hope for a new PostgreSQL era?
Next
From: Chris Redekop
Date:
Subject: Re: Database system identifier via SELECT?