Postgres Pro
Downloads
Home   >   mailing lists

Thread: Be careful in postgresql.conf of 8.1.

Be careful in postgresql.conf of 8.1.

From
"Hiroshi Saito"
Date:
Hi Andreas.

Although this is a comment, it is bad condition.

postgresql.conf

#data_directory = 'ConfigDir'           # use data in another directory
#hba_file = 'ConfigDir/pg_hba.conf'     # host-based authentication file
#ident_file = 'ConfigDir/pg_ident.conf  # IDENT configuration file

Ummm, This should be as follows.

#ident_file = 'ConfigDir/pg_ident.conf'  # IDENT configuration file

It is conf-editor gets confused. What do you consider?

Regards,
Hiroshi Saito

Re: Be careful in postgresql.conf of 8.1.

From
Andreas Pflug
Date:
Hiroshi Saito wrote:
> Hi Andreas.
>
> Although this is a comment, it is bad condition.
>
> postgresql.conf
>
> #data_directory = 'ConfigDir'           # use data in another directory
> #hba_file = 'ConfigDir/pg_hba.conf'     # host-based authentication file
> #ident_file = 'ConfigDir/pg_ident.conf  # IDENT configuration file
>
> Ummm, This should be as follows.
>
> #ident_file = 'ConfigDir/pg_ident.conf'  # IDENT configuration file
>
> It is conf-editor gets confused. What do you consider?

pgsql needs fix.

Regards,
Andreas

Possible bug renaming roles

From
Antonio
Date:
Dear Sirs:

I looked in the pgAdmin web page for a place to report bugs, but I
couldn't find it. So I send it to this list. If I'm wrong, please let me
know.


Bug description:
- When you try to rename a role, you get an error. The underlying sql
sentence seems to be wrong. PgAdmin is trying
    ALTER GROUP ROLE "AccTotBDProy" RENAME TO "BDProy_AccTot";
and then the user gets the error


Expected results:
- It seems pgAdmin should try
    ALTER ROLE "AccTotBDProy" RENAME TO "BDProy_AccTot";
and rename it


I'm available to do whatever tryings are needed.

Keep up the good work. Thanks for it all!

Re: Be careful in postgresql.conf of 8.1.

From
"Hiroshi Saito"
Date:
> > #ident_file = 'ConfigDir/pg_ident.conf'  # IDENT configuration file
> >
> > It is conf-editor gets confused. What do you consider?
>
> pgsql needs fix.

Ok, I will post.

Regards,
Hiroshi Saito

Re: Possible bug renaming roles

From
Andreas Pflug
Date:
Antonio wrote:
> Dear Sirs:
>
> I looked in the pgAdmin web page for a place to report bugs, but I
> couldn't find it. So I send it to this list. If I'm wrong, please let me
> know.
>
>
> Bug description:
> - When you try to rename a role, you get an error.

Fixed in svn for 1.4.1 and HEAD, thanks for reporting.

Regards,
Andreas