Hello NG,

if I installed PostgreSQL 8.2.4-1 at a Windows
Vista plattform with a NTFS filesystem at "C:\pqsql\82"
and choosing an own user, which I created before.
No extra rigths, user: "mypgsql" and password: "mypgsql"

The dateabase runs normal and in the usual way,
that I expected and can stop/start the server
anytime...

But if uninstall the default service wich was
created by the installer and typing this:

pg_ctl unregister -N pgsql-8.2

and then install the same user _and_ same password
_and_ the same database (same place/rights) which was
created by the installer, but with a diffrent
service-name like "pgsql" and type this:

pg_ctl register -N pgsql -U mypgsql -P mypgsql -D "C:\pqsql\82\data"

all is fine, but...

if I try to start the service/server I got this error:

-----
postgres cannot access the server configuration
file "C:/pqsql/82/data/postgresql.conf": No
such file or directory
-----
(one line)

Why?

I have the same database, user, password and
the same rights which were set by the installer for this
user and it schould work. Right?

But... why not?

Thomas Steinbach <steinbach (AT) gmx-topmail (DOT) de> wrote:
You know how to create suspense :^)

Now tell us - is there a file C:/pqsql/82/data/postgresql.conf or not?

Yours,
Laurenz Albe

Hello Laurenz


Yes there are all these files like postgresql.conf hba.conf etc.
The database is the one created by the installer with the
default values at the default path, but with LATIN1 character
set and a diffrent superuser account name.
I only changed the name of the service

Thomas

Thomas Steinbach <steinbach (AT) gmx-topmail (DOT) de> wrote:
Unfortunately I have no idea of Windows, but my first guess would be that
it is a permission problem. Try to logon as the user that tries to run the
postgres.exe executable and see if you can access the files!

Yours,
Laurenz Albe

Hello,

Yes I thought this too and this could be a permission problem.
But it shouldn't, because its the same (running) user, the same
password for this running user and just a diffrent superuser-
account-name for the database, but all was set by the installer
and was working fine, until I change the servicename...

No I try to install only a diffrent servicename - that's all.
And then I got the error decribed above

Perhaps I have to pass some extra Options with the -w Switch
to tell the pg_ctl that there is a diffrent superuseraccountname?
Default is "postgres" and I changed that to "admin"

Thomas Steinbach <steinbach (AT) gmx-topmail (DOT) de> wrote:
Why not find the cause before you start messing around?

Did you try to log on as that user and access the file?

Yours,
Laurenz Albe

Hello Laurenz,

I have read and write access with this account
to the postgresql.conf file...
I have read/write acess to the data dir, but
only read/execute rights to the other dirs
but I think that is right... These rights were
set by the installer...

Hope that someone has an idea...

Hello Laurenz,

now, I get this error in a windows Message-Box:
with an exclamation mark in a yellow triangle

--------------------------------------------------
Services
--------------------------------------------------
The pgsql82 service on Local Computer started and
then stopped.
Some services stop automatically if there are not
in user by other services or programs | OK |
--------------------------------------------------

??? I'm wondering about this message. Because the
service runs before, only the servic-name has
changed...

Thomas Steinbach <steinbach (AT) gmx-topmail (DOT) de> wrote:
It's hard to say, particulary since I have no clue about Windows.

Is there anything in the server log file?

Maybe, if you cannot find any other solution, you can just sweep the
computer clean and install everything again...

Yours,
Laurenz Albe