[pgadmin-support] Application compatibility with Windows7

2010-01-14 Thread Windows 7 Compatibility
Dear Support Team, Our firm is currently in the process of evaluating an upgrade to Windows 7. As a part of this process, we are conducting an audit of Windows 7 compatibility for various applications used by our employees. We were unable to find compatibility details for

[pgadmin-support] Forgotten Password

2010-01-14 Thread hunwei lee
Hi, I've trying to back up my database for PostgreSQL (i'm using it wiht Hold'em Manager) but i've forgotten my password. Can i retrieve or reset the password? Thanks. Andy

Re: [pgadmin-support] can't get pgpass.conf to work with pgagent

2010-01-14 Thread Rathod, Aashish
I can't use pgagent to use the pgpass.conf file in order to schedule backups on my laptop. The pgpass.conf functionality works with a plain psql console but not with pgadmin's pgagent functionality. The pgpass.conf file is located in the proper locations. Thanks Aashish K. Rathod Sr. IT Busin

Re: [pgadmin-support] Slow connect due to some queries

2010-01-14 Thread Tzvi R
Hi, A quick overview of our database server: * Four databases. * Each database has about 20 schemas. The largest database contains: * select count(*) from pg_class where relkind = 'v' 101 * select count(*) from pg_class where relkind = 'r' 11911 (about 500 tables in each schema, I know,

Re: [pgadmin-support] pgAdminII support question

2010-01-14 Thread Guillaume Lelarge
Le 07/12/2009 18:09, David Leikis a écrit : > I am trying to create auto-incrementing of the Primary Key within each record > by using sequences. > > Sometimes I can get the "add - sequence" to work by creating it with the name > "tablename_columnname_seq". > > There are many other times that t

Re: [pgadmin-support] can't get pgpass.conf to work with pgagent

2010-01-14 Thread Guillaume Lelarge
Hi, Le 13/01/2010 01:03, Rathod, Aashish a écrit : > [...] > PostgreSQL 8.4SS > pgAdmin v1.10.01 > English > Binary Distribution from EnterpriseDB > > so what's going on? > > pg_dump and pg_dumpall just keep running in the background > > i have a pgpass.conf in two places - one for me, and one

Re: [pgadmin-support] Slow connect due to some queries

2010-01-14 Thread Guillaume Lelarge
Hi, Le 13/01/2010 17:16, Tzvi R a écrit : > [...] > I've been using pgAdmin for a long time but over time it has become more and > more frustrating to use it. > It's a great application that performs everything I need, however, when first > connecting to servers with many databases, each with ma

Re: [pgadmin-support]

2010-01-14 Thread Guillaume Lelarge
Le 14/01/2010 19:04, Abdallah MEHDOINI a écrit : > Bonjour > > besoin de cours sur l'utilisation de postgres sql > Ceci une liste de discussion en anglais seulement. Merci d'utiliser l'anglais dans vos messages. Si vous ne parlez pas anglais, contactez-moi directement. La documentation sur Po

[pgadmin-support]

2010-01-14 Thread Abdallah MEHDOINI
Bonjour besoin de cours sur l'utilisation de postgres sql merci s 'il y un quelqu'un peut m'aider merci " Ce courriel et les documents qui y sont attaches peuvent contenir des informations confidentielles. Si vous n'etes pas le destinataire escompte, merci d'en informer l'expediteur im