Re: 'Weird' errors

From: Martin Gainty <mgainty(at)hotmail(dot)com>
To: Tom State of Pa <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <dev(at)archonet(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 'Weird' errors
Date: 2009-09-17 21:56:38
Message-ID: BLU142-W16849B04FD6B701859651BAEE10@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


i was able to get it sorted out with the latest release these initdb and pg_ctl commands as follows
initdb --pgdata=/pgsql/data

#####postgresql.conf contents consist of
# this is a comment

#what port to run on
port = 5432

#hostname or address on which the postmaster is to listen for connections from client applications
#virtual_host = 'localhost'

#prints a line informing about each successful connection to the server log
log_connections = true

#prefixes each server log message with a timestamp
#log_timestamp = true
#determines how many concurrent connections the database server will allow
max_connections = 3
#######end postresql.conf

######### START pg_hba.conf
# Allow any user on the local system to connect to any database under
# any database user name using Unix-domain sockets (the default for local
# connections).
#
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust
#####END pg_hba.conf

############start PG VERSION
8.4
############END PG_VERSION file

$ /cygdrive/c/postgres/pgsql/bin/pg_ctl -D "/pgsql/data" -l logfile start

server starting

thanks tom
Martin
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

> To: mgainty(at)hotmail(dot)com
> CC: dev(at)archonet(dot)com; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 'Weird' errors
> Date: Thu, 17 Sep 2009 17:25:07 -0400
> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
>
> Martin Gainty <mgainty(at)hotmail(dot)com> writes:
> > i flipped to my regular account and re-created the db with initdb -D newFolder
> > i have noticed that initdb basically deletes everything ..and the reason for doing that would be?
>
> Oh? It should refuse to do anything if the target directory is not
> empty; and does act that way, in my testing.
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
Hotmail: Free, trusted and rich email service.
http://clk.atdmt.com/GBL/go/171222984/direct/01/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alan McKay 2009-09-17 22:00:44 Re: limiting query time and/or RAM
Previous Message Tom Lane 2009-09-17 21:47:49 Re: haversine formula with postgreSQL