pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgadmin3: can't locate server: what am I doing wrong?
3+ messages / 2 participants
[nested] [flat]
* pgadmin3: can't locate server: what am I doing wrong?
@ 2010-12-13 16:20 Fred Parkinson <FredP@abag.ca.gov>
0 siblings, 1 reply; 3+ messages in thread
From: Fred Parkinson @ 2010-12-13 16:20 UTC (permalink / raw)
To: pgsql-admin
I am a longtime user of postgersql, using it as a backend and using odbc to connect and it has been an amazingly stable and useful database manager.
Now, a longtime Windows user (disgruntled) I am trying to set up a development platform on a local Suse Linux box which includes a local install of postgresql.
Last week I successfully installed postgersql and created a database, but today pgadmin3 doesn't seem to find it!
Using the unix ps command I see there are postgre processes running, so the server is up.
Logged in as user postgre and invoking pgadmin3, 'Server Groups' is empty.
logged in as user root and 'server groups' is empty.
logged in as fredrated and the server is there.
Can someone explain what this means? Why is the server only visible to this user?
Thanks, Fred
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgadmin3: can't locate server: what am I doing wrong?
@ 2010-12-13 16:32 Guillaume Lelarge <guillaume@lelarge.info>
parent: Fred Parkinson <FredP@abag.ca.gov>
0 siblings, 1 reply; 3+ messages in thread
From: Guillaume Lelarge @ 2010-12-13 16:32 UTC (permalink / raw)
To: Fred Parkinson <FredP@abag.ca.gov>; +Cc: pgsql-admin
Le 13/12/2010 17:20, Fred Parkinson a écrit :
> I am a longtime user of postgersql, using it as a backend and using odbc to connect and it has been an amazingly stable and useful database manager.
>
> Now, a longtime Windows user (disgruntled) I am trying to set up a development platform on a local Suse Linux box which includes a local install of postgresql.
> Last week I successfully installed postgersql and created a database, but today pgadmin3 doesn't seem to find it!
> Using the unix ps command I see there are postgre processes running, so the server is up.
>
> Logged in as user postgre and invoking pgadmin3, 'Server Groups' is empty.
> logged in as user root and 'server groups' is empty.
> logged in as fredrated and the server is there.
>
> Can someone explain what this means? Why is the server only visible to this user?
>
Because only this user has configured access to this server. pgAdmin can
sometimes auto-detect local servers, but you shouldn't rely on this.
Usually, you should add them yourself to pgAdmin (first button on the
toolbar).
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgadmin3: can't locate server: what am I doing wrong?
@ 2010-12-13 16:47 Fred Parkinson <FredP@abag.ca.gov>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 3+ messages in thread
From: Fred Parkinson @ 2010-12-13 16:47 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-admin
Thank you for your quick and accurate reply.
I logged in as root, picked the 'add a connection...' option you
suggested and voila! The server is now visible to pgadmin3/root user.
Thanks again, Fred
>>> Guillaume Lelarge <guillaume@lelarge.info> 12/13/2010 8:32 AM >>>
Le 13/12/2010 17:20, Fred Parkinson a écrit :
> I am a longtime user of postgersql, using it as a backend and using
odbc to connect and it has been an amazingly stable and useful database
manager.
>
> Now, a longtime Windows user (disgruntled) I am trying to set up a
development platform on a local Suse Linux box which includes a local
install of postgresql.
> Last week I successfully installed postgersql and created a database,
but today pgadmin3 doesn't seem to find it!
> Using the unix ps command I see there are postgre processes running,
so the server is up.
>
> Logged in as user postgre and invoking pgadmin3, 'Server Groups' is
empty.
> logged in as user root and 'server groups' is empty.
> logged in as fredrated and the server is there.
>
> Can someone explain what this means? Why is the server only visible
to this user?
>
Because only this user has configured access to this server. pgAdmin
can
sometimes auto-detect local servers, but you shouldn't rely on this.
Usually, you should add them yourself to pgAdmin (first button on the
toolbar).
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-12-13 16:47 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-13 16:20 pgadmin3: can't locate server: what am I doing wrong? Fred Parkinson <FredP@abag.ca.gov>
2010-12-13 16:32 ` Guillaume Lelarge <guillaume@lelarge.info>
2010-12-13 16:47 ` Fred Parkinson <FredP@abag.ca.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox