Re: Setting up security for development - Mailing list pgsql-novice

Below are the errors that are being created on the Database server when I
try to start the db.  Is it possible that the error is occuring because the
postgres userid is in Active Directory as a regular user and it has a
password set?  I don't want to have to give a password everytime I try and
start the service.

This is under the System in the Windows Logs

The PostgreSQL Server 8.4 service failed to start due to the following
error:
The service did not respond to the start or control request in a timely
fashion.
Event Error: 7000/7009

This is the message under the Application Windows Log

Faulting application pg_ctl.exe, version 8.4.0.9177, time stamp 0x4a468e1d,
faulting module libintl-8.dll, version 6.0.6001.18000, time stamp
0x4791a783,
exception code 0xc0000135, fault offset 0x0006ecfb, process id 0x1364,
application start time 0x01ca00ae9b30082a.

Source:  Application Error
Event ID: 1000
Level: Error
User: N/A
Looged 7/9/2009 12:02:06PM
Task Category (100)
Keywords: Classic
Computer IssDevServer.issdev.local







"Michael Gould" <mgould@intermodalsoftwaresolutions.net> wrote:
> I am having some issues trying to setup security for my development
> platform.  My server is running Windows 2008 Standard Server.  I've
> installed PostGres on this machine. Before installing, I had created a
> postgres user in active directory with permissions of a standard user.
>
> I have two workstations, one is Windows Vista 64 bit (also used as my VM
> host) and my main development machine is a Windows Vista 32 bit VM running
> on VMWare 6.5.  The IP address range is 192.168.1.25 to 192.168.1.255.
>
> Here are the pertinate parts from the pg_hba file.  Without the local
being
> available the service will not start.  It is my understanding that if I'm
> going to connect using TCPIP that the localhost should not be used.  For
now
> I'm using trust just to see if I can get it to start.  When we actually
> deploy we will be using LDAP services. If I have localhost activated only
> then I can start the db and open up pgadmin and connect just fine.  If it
is
> commented out the db service will not start.  I'm needing to set this up
so
> any of my 5 machines can access the db.  Running 8.4
>
> Best Regards
>
> Michael Gould
>
> # Put your actual configuration here
> # ----------------------------------
> #
> # If you want to allow non-local connections, you need to add more
> # "host" records. In that case you will also need to make PostgreSQL
listen
> # on a non-local interface via the listen_addresses configuration
parameter,
> # or via the -i or -h command line switches.
> #
>
>
>
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>
> # IPv4 local connections:
> #host    all         all         127.0.0.1/32
> host    all         all         192.168.1.0/32 255.255.255.0        trust
> # IPv6 local connections:
> host    all         all         ::1/128               md5
>
>
> --
> Michael Gould, Managing Partner
> Intermodal Software Solutions, LLC
> 904.226.0978
> 904.592.5250 fax
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax