Thread: How to load the real pgsql.conf and pg_hba.conf ?
Hi list,<br /><br />I tryed to open the pg_hba.conf and pgsql.conf from my server but it was in a linux system and I am ina Windows system.<br /><br />How to open this files without copying from my computer ?<br /><br />Is it possible ? <br/><br />Regards...<br clear="all" /><br />-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br /> Atenciosamente(Sincerely)<br /> Ezequias Rodrigues da Rocha <br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br /><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha
Sent: 26 September 2006 12:29
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] How to load the real pgsql.conf and pg_hba.conf ?Hi list,
I tryed to open the pg_hba.conf and pgsql.conf from my server but it was in a linux system and I am in a Windows system.
How to open this files without copying from my computer ?
Is it possible ?
Yes, you need the adminpack (instrumentation functions) loaded into your maintenance database first (http://www.pgadmin.org/download/adminpacks.php), and then you'll be able to edit those files by selecting the options on the Tools -> Server Configuration menu.
Regards, Dave.
Thank you Dave, It looks there isn't a version to pgAdmin 1.6 allright ?
There is any problem to use an older version of adminpacks ?
Regards
Ezequias
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
There is any problem to use an older version of adminpacks ?
Regards
Ezequias
2006/9/26, Dave Page < dpage@vale-housing.co.uk>:
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha
Sent: 26 September 2006 12:29
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] How to load the real pgsql.conf and pg_hba.conf ?Hi list,
I tryed to open the pg_hba.conf and pgsql.conf from my server but it was in a linux system and I am in a Windows system.
How to open this files without copying from my computer ?
Is it possible ?
Yes, you need the adminpack (instrumentation functions) loaded into your maintenance database first (http://www.pgadmin.org/download/adminpacks.php ), and then you'll be able to edit those files by selecting the options on the Tools -> Server Configuration menu.Regards, Dave.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
From: Ezequias Rodrigues da Rocha [mailto:ezequias.rocha@gmail.com]
Sent: 26 September 2006 20:24
To: Dave Page
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] How to load the real pgsql.conf and pg_hba.conf ?Thank you Dave, It looks there isn't a version to pgAdmin 1.6 allright ?
There is any problem to use an older version of adminpacks ?
No, it's the same as the older version. Note that form PostgreSQL 8.2, it will be included in /contrib, rather than bundled with pgAdmin.
Regards, Dave
It's not an application, it's a set of functions that can be called through libpq using normal SQL that allow pgAdmin to read and write files on the server - such as the config and log files.
Regard,s Dave.
I didn't noticed that it is a server-side application. Could you tell me what it really does ? I just want to manager the pgserver without using putty and vi.
From: Ezequias Rodrigues da Rocha [mailto:ezequias.rocha@gmail.com]
Sent: 27 September 2006 13:28
To: Dave Page
Subject: Re: [pgadmin-support] How to load the real pgsql.conf and pg_hba.conf ?
Notthing against puttty or vi but I just want to concentrate all work on one application.
Regards...
Ezequias2006/9/27, Dave Page <dpage@vale-housing.co.uk>:It's for *nix and Windows... but, if you are running the server on Windows then the adminpack is already included in installer version. Look for the admin81.sql or admin80.sql file in your installation and run that in your maintenance DB.Regards, DaveThank you Dave, but the link you mentioned is for linux distributions. Maybe I didn't understand your first e-mail.
From: Ezequias Rodrigues da Rocha [mailto:ezequias.rocha@gmail.com]
Sent: 27 September 2006 12:33
To: Dave Page
Subject: Re: [pgadmin-support] How to load the real pgsql.conf and pg_hba.conf ?
Sincerely
Ezequias2006/9/27, Dave Page < dpage@vale-housing.co.uk>:
From: Ezequias Rodrigues da Rocha [mailto:ezequias.rocha@gmail.com]
Sent: 26 September 2006 20:24
To: Dave Page
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] How to load the real pgsql.conf and pg_hba.conf ?Thank you Dave, It looks there isn't a version to pgAdmin 1.6 allright ?
There is any problem to use an older version of adminpacks ?
No, it's the same as the older version. Note that form PostgreSQL 8.2, it will be included in /contrib, rather than bundled with pgAdmin.Regards, Dave
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/