Re: PostgreSQL for NT

Поиск
Список
Период
Сортировка
От W. van den Akker
Тема Re: PostgreSQL for NT
Дата
Msg-id 003c01c05be5$67cbecf0$0400020a@wilsoft.nl
обсуждение исходный текст
Ответ на PostgreSQL for NT  ("W. van den Akker" <wvdakker@wilsoft.nl>)
Ответы Re: PostgreSQL for NT  (Jason Tishler <Jason.Tishler@dothill.com>)
Список pgsql-ports
Дерево обсуждения
Jason,
 
All mounts are in binary mode. So that sounds ok. Next I have compiled and installed postgres 7.03
like discribed in Tishlers docu. All went ok.
If I start postmaster I get:

$ DEBUG:  Data Base System is starting up at Fri Dec  1 22:57:01 2000
DEBUG:  Data Base System was interrupted being in production at Fri Dec  1 18:48:58 2000
DEBUG:  Data Base System is in production state at Fri Dec  1 22:57:01 2000
 
Then I try to start psql -h localhost template1 and get:
 
$ psql -h localhost template1
NOTICE:  mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
NOTICE:  mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
NOTICE:  mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_variable: No such file or directory
NOTICE:  mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
FATAL 1:  cannot open relation pg_log
NOTICE:  mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_variable: No such file or directory
NOTICE:  mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
psql: FATAL 1:  cannot open relation pg_log
 
The /usr/local/pgsql/data directory looks like:
 
$ ls -al
total 47
drwxr-xr-x   4 wvdakker None         4096 Dec  1 22:57 .
drwxr-xr-x   6 wvdakker None            0 Dec  1 16:14 ..
-rw-r--r--   1 wvdakker None            4 Dec  1 18:30 PG_VERSION
drwxr-xr-x   3 wvdakker None            0 Dec  1 18:30 base
-rw-r--r--   1 wvdakker None         8192 Dec  1 22:57 pg_control
-rw-r--r--   1 wvdakker None         8192 Dec  1 18:30 pg_database
-r--r--r--   1 wvdakker None         3407 Dec  1 18:30 pg_geqo.sample
-rw-r--r--   1 wvdakker None            0 Dec  1 18:30 pg_group
-rw-r--r--   1 wvdakker None        16384 Dec  1 18:30 pg_group_name_index
-rw-r--r--   1 wvdakker None        16384 Dec  1 18:30 pg_group_sysid_index
-r--r--r--   1 wvdakker None         5729 Dec  1 18:30 pg_hba.conf
-rw-r--r--   1 wvdakker None         8192 Dec  1 18:30 pg_log
-rw-r--r--   1 wvdakker None         8192 Dec  1 18:30 pg_shadow
-rw-r--r--   1 wvdakker None         8192 Dec  1 18:30 pg_variable
drwxr-xr-x   2 wvdakker None            0 Dec  1 18:30 pg_xlog
-rw-r--r--   1 wvdakker None          122 Dec  1 22:57 postmaster.opts
-r--r--r--   1 wvdakker None            1 Dec  1 18:30 postmaster.opts.default
-rw-r--r--   1 wvdakker None            4 Dec  1 22:57 postmaster.pid
 
I also exported all environment variables, PGDATA PGLIB and PATH.
I'am running this on NT4 SP6.
 
Any ideas?
 
gr,
Willem
 
----- Original Message -----
From: "Jason Tishler" <Jason.Tishler@dothill.com>
To: "W. van den Akker" <wvdakker@wilsoft.nl>
Cc: "Peter Eisentraut" <peter_e@gmx.net>; <pgsql-ports@postgresql.org>
Sent: Monday, November 27, 2000 7:09 PM
Subject: Re: [PORTS] PostgreSQL for NT

> Willem,
>
> On Thu, Nov 23, 2000 at 10:33:49PM +0100, W. van den Akker wrote:
> >    C:\Postgres>psql -h localhost -d template1
> >    psql: Missing or erroneous pg_hba.conf file, see postmaster log for
> >    details
>
> The above is caused by your pg_hba.conf file being a text mode (i.e.,
> has CRNL instead of NL line endings) file.  Convert it to a binary mode
> file and the above error with be eliminated.
>
> My guess is that your editor accidentally converted pg_hba.conf to text
> mode when your were editing it.  Otherwise, you installed Cygwin with
> text mode mounts as your default.  You can determine this by using mount,
> as in:
>
>     $ mount
>     Device              Directory           Type         Flags
>     C:\Cygwin\bin       /usr/bin            system       binmode
>     C:\Cygwin\lib       /usr/lib            system       binmode
>     C:\Cygwin           /                   system       binmode
>     ...
>
> If the Flags indicate "textmode" instead of "binmode", then execute
> something like the following:
>
>     $ mount -f -b -s C:/Cygwin /
>     $ mount -f -b -s C:/Cygwin/bin /usr/bin
>     $ mount -f -b -s C:/Cygwin/lib /usr/lib
>
> Otherwise, rerun Cygwin's setup.exe and choose "Unix" for the "Default
> Text File Type".
>
> BTW, you may want to reinstall PostgreSQL, since other files may have
> been converted to text mode.
>
> Jason
>
> --
> Jason Tishler
> Director, Software Engineering       Phone: +1 (732) 264-8770 x235
> Dot Hill Systems Corporation         Fax:   +1 (732) 264-8798
> 82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
> Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com
>
>

В списке pgsql-ports по дате отправления:

Предыдущее
От: Jason Tishler
Дата:
Сообщение: Re: PostgreSQL for NT
Следующее
От: Jason Tishler
Дата:
Сообщение: Re: PostgreSQL for NT