Re: run postgres 8.3 - Mailing list pgsql-general

From Joao Ferreira gmail
Subject Re: run postgres 8.3
Date
Msg-id 1224063576.6810.6.camel@jmf-ubuntu
Whole thread Raw
In response to run postgres 8.3  ("Eduardo Arévalo" <earevaloch@gmail.com>)
List pgsql-general
Hello Eduardo


On Tue, 2008-10-14 at 15:40 -0500, Eduardo Arévalo wrote:
> I installed the 8.3 postgres
> the amount of giving the command:
> bash-3.2$ /usr/local/postgres_8.3/bin/initdb -D /base/data
>

that command only initializes the underlying filesystem database files,
directories and configurations

the command that starts the database system (if you do not wish to use
init scripts, as seems to be the case) is something like:


         su - postgres -c '/usr/bin/pg_ctl start -w -D /var/pgsql/data \
                         -l /var/pgsql/data/logfile -o "-i"'
                evaluate_retval
                ;;




> the result is:
>
>
> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale en_US.UT F-8.
> The default database encoding has accordingly been set to UTF8.
> The default text search configuration will be set to "english".
>
> initdb: directory "/base/data" exists but is not empty
> If you want to create a new database system, either remove or empty
> the directory "/base/data" or run initdb
> with an argument other than "/base/data".

you must remove that directory  (or it's contents ) first:

try one of these:

rm -rf /base/*
rm -rf /base/data/*

only after this removal retry the initdb command.

after that try the start command

.... BTW, use something like

/usr/bin/pg_ctl stop

to stop your DB....


BTW: why aren't you using your distribution's packages.... they should
work just fine :)

cheers
joao


>
>
> but do not raise your service
>
>
>


pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: making trigger on delete, set 'affected rows' correctly
Next
From: "Alain Roger"
Date:
Subject: user and default schema