Обсуждение: How to load the real pgsql.conf and pg_hba.conf ?

Поиск
Список
Период
Сортировка

How to load the real pgsql.conf and pg_hba.conf ?

От
"Ezequias Rodrigues da Rocha"
Дата:
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> 

Re: How to load the real pgsql.conf and pg_hba.conf ?

От
"Dave Page"
Дата:
 


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.

Re: How to load the real pgsql.conf and pg_hba.conf ?

От
"Ezequias Rodrigues da Rocha"
Дата:
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

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/

Re: How to load the real pgsql.conf and pg_hba.conf ?

От
"Dave Page"
Дата:
 


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 

Re: How to load the real pgsql.conf and pg_hba.conf ?

От
"Dave Page"
Дата:
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.


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 ?

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.

Notthing against puttty or vi but I just want to concentrate all work on one application.

Regards...
Ezequias

2006/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, Dave


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 ?

Thank you Dave, but the link you mentioned is for linux distributions. Maybe I didn't understand your first e-mail.

Sincerely
Ezequias

2006/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/