Re: [pgadmin-support] Getting Started
Rainer I can not connect to cluster/server. I did restart the server, do I have to reload config file as well. How do I do that? Ian -Original Message- From: Rainer Bauer [mailto:use...@munnin.com] Sent: 08 September 2009 21:44 To: pgadmin-support@postgresql.org Cc: Ian Waterman Subject: Re[2]: [pgadmin-support] Getting Started Hello Ian, please CC the list. Tuesday, September 8, 2009, 10:48:26 AM, you wrote: IW> Thanks for your mail. However, its not the DB password but the Server IW> password. Yes. When you connect the the cluster (i.e. what you call "Server"), pgAdminIII will automatically connect you to the database "postgres". IW> When I try to connect to the localhost server it opens a password IW> dialog box. Did you restart the server (or reload the config?) after altering pg_hba.conf? Rainer No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.86/2355 - Release Date: 09/08/09 20:45:00 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] pgAdmin requires password
I have modified the C:\Program Files\PostgreSQL\8.4\data\pg_hba.conf file to allow anyone to access any database without a password: hostall all 127.0.0.1/32 trust The problem is, when I start pgAdmin, it requests the password for user postgres. I thought the pg_hba.conf file would eliminate the need for the password for pgAdmin. Jayson Prichard Northrop Grumman Warner Robins Avionics Engineering Sustainment Center Senior Software Engineer 293 Highway 247 South Warner Robins, Ga. 31088 478.929.7349
Re: [pgadmin-support] pgAdmin requires password
On Wed, Sep 9, 2009 at 3:56 PM, Prichard, Jayson S (TS) wrote: > I have modified the C:\Program Files\PostgreSQL\8.4\data\pg_hba.conf file to > allow anyone to access any database without a password: > > > > host all all 127.0.0.1/32 trust > > > > The problem is, when I start pgAdmin, it requests the password for user > postgres. I thought the pg_hba.conf file would eliminate the need for the > password for pgAdmin. pgAdmin has no idea that a password isn't required until the connection is attempted. Just save an empty (or any other password) and it shouldn't ask again (unless the connection fails for some reason). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] pgAdmin requires password
On Wed, Sep 9, 2009 at 7:54 PM, Prichard, Jayson S (TS) wrote: > Dave, > > That was my suggestion: if PostgreSQL uses the pg_hba.conf file for > authentication, perhaps pgAdmin should/could as well. It has no idea where it is until a connection is established - and in most cases couldn't access it until then, even if it remembered from a previous session (and wouldn't know if you'd revoked 'trust' in the meantime). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] Possible simple enhancement
First of all thanks for PGAdmin I've been using it for years now. One small enhancement that would be very useful is: When viewing the Statistics tab for the server where the Current Executing Queries is available (along with the current user, database etc..) It would be good to be able to copy the sql of a current query. I realize that it is impractical to show the full query sql (and do not want this). But I would like to be able to copy the "full sql" of the current query. I know that I can log long running queries, but feel it would be useful to copy the query from the statistics, so I can paste it into a query window for further analysis. Thanks, Roger -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
