PostegreSQL 8.0.0 Beta4 Win32 - Mailing list pgsql-general

From Secrétariat
Subject PostegreSQL 8.0.0 Beta4 Win32
Date
Msg-id 001e01c4ce4e$dd582990$0a00a8c0@lrp43008
Whole thread Raw
Responses Re: PostegreSQL 8.0.0 Beta4 Win32
List pgsql-general
Hello !
 
The RC2 is great but :
I use an other filesystem for the data.
So I have C:\Program file\PostgreSQL... and I have F:\PostgreSQL\8.0.0-beta4\data.
 
In the file C:\Program Files\PostgreSQL\8.0.0-beta4\data\postgresql.conf I modify the files locations :
data_directory = 'F:/PostgreSQL/8.0.0-beta4/data'
hba_file = 'F:/PostgreSQL/8.0.0-beta4/data/pg_hba.conf'
ident_file = 'F:/PostgreSQL/8.0.0-beta4/data/pg_ident.conf'.
 
The file F:\PostgreSQL\8.0.0-beta4\data\pg_hba.conf contain :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local     all                all                                md5
# IPv4 local connections:
host     all                 all      127.0.0.1/32        md5
host     all                all     192.168.0.0/24    md5
# IPv6 local connections:
#host    all                 all       ::1/128               md5
 
On the localhost (192.168.0.10) with pgAdmin III (1.20 RC2),
I can't connect like localhost (localhost, beta4, pgsql-8.0.0-beta4, 5432, template1, postgres, ****)
but I can connect like an host (192.168.0.10, beta4, , 5432, template1, postgres, ****) !?
Before I split the data on an other disk I can connect as 'localhost'.
Shall I make a mistake, is it a bug ?
 
Some wishes :
- The win32 install let choose an alternate disk for the data ...
- The win32 install use the user variable PGDATA for the links towards configuration files (in ex. %PGDATA%\pg_hba.conf), it's more efficient when putting data on another disk.
 
You're doing a great job !
Best regards.
 
Luc ROLLAND

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Phantom user in db--'128'
Next
From: Adam Witney
Date:
Subject: Can COPY skip a header line?