From: Guillaume Lelarge <guillaume@lelarge.info>
To: Fred Parkinson <FredP@abag.ca.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: pgadmin3: can't locate server: what am I doing wrong?
Date: Mon, 13 Dec 2010 17:32:05 +0100
Message-ID: <4D064A85.5040001@lelarge.info> (raw)
In-Reply-To: <4D05D767020000A7000151F7@gwia1.abag.ca.gov>
References: <4D05D767020000A7000151F7@gwia1.abag.ca.gov>
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.frhttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, FredP@abag.ca.gov
Subject: Re: pgadmin3: can't locate server: what am I doing wrong?
In-Reply-To: <4D064A85.5040001@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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