Re: [Gnumed-devel] bootstrapping database problem

[Florian Hubold]

Karsten Hilbert schrieb:
> On Wed, Jul 16, 2008 at 01:38:44PM +0200, Florian Hubold wrote:
>
>   
> > Actually postgresql on mandriva comes only with postgresql.conf,
> >     
> Pray tell. That seems mighty strange. IOW, after a default
> install of PostgreSQL no user will be able to login at all ?
>
> My PostgreSQL does not even start without that file. I would
> assume it is hidden somewhere under /etc/. Have a look at
> postgresql.conf -> hb_file = ...
Here is an excerpt from an otherwise unchanged postgresql file on
mandriva 2008.1
after installation and initialization of postgresql server.

   # -----------------------------
   # PostgreSQL configuration file
   # -----------------------------
   #
   # This file consists of lines of the form:
   #
   #   name = value
   #
   # (The "=" is optional.)  Whitespace may be used.  Comments are
   introduced with
   # "#" anywhere on a line.  The complete list of parameter names and
   allowed
   # values can be found in the PostgreSQL documentation.
   #
   # The commented-out settings shown in this file represent the
   default values.
   # Re-commenting a setting is NOT sufficient to revert it to the
   default value;
   # you need to reload the server.
   #
   # This file is read on server startup and when the server receives a
   SIGHUP
   # signal.  If you edit the file on a running system, you have to
   SIGHUP the
   # server for the changes to take effect, or use "pg_ctl reload".  Some
   # parameters, which are marked below, require a server shutdown and
   restart to
   # take effect.
   #
   # Any parameter can also be given as a command-line option to the
   server, e.g.,
   # "postgres -c log_connections=on".  Some paramters can be changed
   at run time
   # with the "SET" SQL command.
   #
   # Memory units:  kB = kilobytes MB = megabytes GB = gigabytes
   # Time units:    ms = milliseconds s = seconds min = minutes h =
   hours d = days



#------------------------------------------------------------------------------
   # FILE LOCATIONS

#------------------------------------------------------------------------------

   # The default values of these variables are driven from the -D
   command-line
   # option or PGDATA environment variable, represented here as ConfigDir.

   #data_directory = 'ConfigDir'        # use data in another directory
                       # (change requires restart)
   #hba_file = 'ConfigDir/pg_hba.conf'    # host-based authentication file
                       # (change requires restart)
   #ident_file = 'ConfigDir/pg_ident.conf'    # ident configuration file
                       # (change requires restart)

   # If external_pid_file is not explicitly set, no extra PID file is
   written.
   #external_pid_file = '(none)'        # write an extra PID file
                       # (change requires restart)



Can you tell me what this looks like on your box and with what distribution?
The only interesting part is the "file locations" one, is this right?