[pgadmin-support] pgadmin II

2013-04-10 Thread Veenu Kumar Mani
Dear Support, We have encountered an issue regarding the pgAdmin shortcut from start menu. Earlier the shortcut for pgadmin was there in Postgresql, but suddenly it got disappeared from the menu. Please help. Regards, Veenu Visit us at Booth No.96 - Bio-IT conference, World trade center, Bost

[pgadmin-support] Password Expiry

2013-04-10 Thread Brett Maton
pgAdmin v 1.16.1 Windows 7 x64 PostgreSQL v9.4.2 CentOS 6.4 pgAdmin by default when editing a user's account settings seems to set Account Validity to '1969-12-31 00:00:00+01' if the role is defined as valid until infinity. This results in the user not being able to

Re: [pgadmin-support] PGAdmin Release 1.16.2

2013-04-10 Thread ldrlj1
Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/PGAdmin-Release-1-16-2-tp5751397p5751592.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make c

Re: [pgadmin-support] Password Expiry

2013-04-10 Thread Dave Page
Hi On Wed, Apr 10, 2013 at 12:31 PM, Brett Maton wrote: > pgAdmin v 1.16.1 > > Windows 7 x64 > > > > PostgreSQL v9.4.2 > > CentOS 6.4 > > > > pgAdmin by default when editing a user’s account settings seems to set > Account Validity to ‘1969-12-31 00:00:00+01’ if the role is

Re: [pgadmin-support] Problem with DEBUG messages

2013-04-10 Thread Dave Page
On Tue, Apr 9, 2013 at 5:00 PM, Michael Shapiro wrote: > Yes and no. > > If I run the script that creates the function, does the set > client_min_messages, then runs the function, > I get the DEBUG. > > But then if I just runt he function (in a new query window). I do not get > the DEBUG messages.

Re: [pgadmin-support] Post Installation PostgreSQL

2013-04-10 Thread James Woods
Hello; I'm using the following installation guide: http://techguide.opr.statefarm.org/index.php/Workstation_Setup_Guide:_PostgreSQL_%26_pgAdmin One step in the section 'Post Installation Verification (Windows)' states: - Enter the postgres password A default password is not provided on th

Re: [pgadmin-support] Post Installation PostgreSQL

2013-04-10 Thread Saad Benateigha
You will need to modify the pg_hba.conf find the line local all postgres peer change the peer (access mode) to trust Save the pg_hba.conf and restart the postgresql server >From a sql shell window type ALTER ROLE postgres with password 'enter new password' --don't forget the single tics

Re: [pgadmin-support] Password Needed

2013-04-10 Thread Saad Benateigha
See recent response - Original Message - From: aka...@sce.carleton.ca To: pgadmin-support@postgresql.org Sent: Tuesday, April 9, 2013 6:31:48 AM Subject: [pgadmin-support] Password Needed Hello, Please i have installed postgresql according to the tutorial in http://www.postgresqlt