Is that a small d or a capital D? try this:
postmaster -D $PGDATA2 -i -p 5431 &
\Indraneel
On Thu, 26 Oct 2000, Brian C. Doyle wrote:
> Okay I am still doing something wrong here
>
> I set PGDATA2=/home/user1/database
> export PGDATA2
>
> then I start postmaster
> postmaster -d PGDATA2 -i -p
Brian C. Doyle writes:
> Okay I am still doing something wrong here
>
> I set PGDATA2=/home/user1/database
> export PGDATA2
>
> then I start postmaster
> postmaster -d PGDATA2 -i -p 5431 &
postmaster -D $PGDATA -i -p 5431 >logfile 2>&1 and i get
>
> Can't create pid file: /usr/local/pgsql/d
Okay...
I can now run as many postmasters as I could imagine... KICK BUTT
I am still running into a problem with the "alternate database
locations" and that is I seem to be able to only set up 1 other alternate
location.
After getting the first alt location setup Iset PGDATA2= /home/use
"Brian C. Doyle" <[EMAIL PROTECTED]> writes:
> Okay I am still doing something wrong here
> I set PGDATA2=/home/user1/database
> export PGDATA2
> then I start postmaster
> postmaster -d PGDATA2 -i -p 5431 &
I think you are confusing the "alternate database directory" stuff with
having a separat
"Brian C. Doyle" <[EMAIL PROTECTED]> writes:
> createdb user1 -D 'PGDATA2'
> it creates but it is putting it in /home/user/database
> the first alt location i set up!!!
Um, are you sure createdb is connecting to the right postmaster?
When you use multiple postmasters you have to keep a close eye
Okay I am still doing something wrong here
I set PGDATA2=/home/user1/database
export PGDATA2
then I start postmaster
postmaster -d PGDATA2 -i -p 5431 &
and i get
Can't create pid file: /usr/local/pgsql/data/postmaster.pid
Is another postmaster (pid: 10686) running?
What am I missing... I know
AFAIK the port number is compiled in, so you need to recompile. It's there
in the docs somewhere. you have to use a different value for --with-pgport
option in ./configure .
On Wed, 25 Oct 2000, Brian C. Doyle wrote:
>
> I am still trying to find out how to get multiple postmasters running on
"Brian C. Doyle" <[EMAIL PROTECTED]> writes:
> I am still trying to find out how to get multiple postmasters running on
> different ports at the same time. Does anyone have any clue how to do that?
Uh, you just do it. Start each postmaster in a different data directory
and with a different por
On Tue, 24 Oct 2000, Brian C. Doyle wrote:
> Never mind... I got it working
OK, don't play your cards so close to the vest. What was the problem (and
solution)?
TIA,
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149
Well I got it working kinda.
You have set up an environment for the new directory and export it under
the PGSQL super user account
PGDATA2=/home/userid
export PGDATA2
Then run
initlocation PGDATA2
After that you have to restart your postmaster with the data dir as PGDATA2
postmaster -d PGDATA
Hello,
I am working on seting up alternate database locations for my users.
I have done
% initlocation /home/userid
% createdb -D /home/userid userid
and i always get
ERROR: The database path '/home/httpd/jbbent' is invalid. This may be due
to a character that is not allowed or because the c
Never mind... I got it working
At 02:40 PM 10/24/00 -0400, Brian C. Doyle wrote:
>Hello,
>
>I am working on seting up alternate database locations for my users.
>I have done
>
>% initlocation /home/userid
>% createdb -D /home/userid userid
>
>and i always get
>
>ERROR: The database path '/home/h
12 matches
Mail list logo