> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of Tom Lane
> Sent: Wednesday, August 10, 2011 4:22 PM
> To: CS DBA
> Cc: PG Admin
> Subject: Re: [ADMIN] initdb fails on AIX
>
> CS DBA writes:
On 08/10/2011 02:22 PM, Tom Lane wrote:
CS DBA writes:
On 08/10/2011 01:16 PM, Tom Lane wrote:
This means that initdb tried to execute "postgres -V" and didn't get any
output. What happens when you try that directly?
See below. One oddity, if I compile without the --with-openssl flag
(for t
CS DBA writes:
> On 08/10/2011 01:16 PM, Tom Lane wrote:
>> This means that initdb tried to execute "postgres -V" and didn't get any
>> output. What happens when you try that directly?
> See below. One oddity, if I compile without the --with-openssl flag
> (for the configure command) then it w
On 08/10/2011 01:16 PM, Tom Lane wrote:
CS DBA writes:
We're getting the following error when we try to run initdb on an AIX box:
fgets failure: Error 0
The program "postgres" is needed by initdb but was not found in the same
directory as "/opt/app/postgres/904/bin/initdb".
Check your installat
CS DBA writes:
> We're getting the following error when we try to run initdb on an AIX box:
> fgets failure: Error 0
> The program "postgres" is needed by initdb but was not found in the same
> directory as "/opt/app/postgres/904/bin/initdb".
> Check your installation.
This means that initdb tr
On Wed, 2005-12-07 at 11:04 -0700, Anne M. Hammond wrote:
> If there is another way to do this, such as command line options
> or environmental values for initdb, I haven't found it.
There's no need to run initdb on the smaller machine.
Run the initdb on the larger machine, then *while postmaste
"Anne M. Hammond" <[EMAIL PROTECTED]> writes:
> However, when the server SHMMAX is smaller than the size required
> by the defaults for shared_buffers and max_connections, I have
> not been able to find a way (other than the above), to tell
> initdb to use a nondefault values.
Well, initdb is just
Summary:
I used a workstation where /usr/local/pgsql was mounted, and
which had a larger SHMMAX. initdb worked there.
Then I returned to the server, edited /usr/local/pgsql/data/pgsql.conf
for smaller sizes than the default shared_buffers and max_connections.
Thanks to Pandu and Tom Lane for
"Anne M. Hammond" <[EMAIL PROTECTED]> writes:
> So the shared memory request is greater than the SHMMAX in
> the kernel. If I just wanted to use a smaller number of shared_buffers
> (24), I tried editing /usr/local/pgsql/data/pgsql.conf.
You're going to have to increase SHMMAX anyway, so you migh
Hi,
The following link will help you
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
On 12/7/05, Anne M. Hammond <[EMAIL PROTECTED]> wrote:
> This is running on a Solaris 8 machine.
>
> I installed V 7.4.7 to use with OpenACS.
>
> lcd[34]% /usr/local/pgsql/bin/initdb -D /usr/loca
Yes. Cygwin IPC Daemon 2 is running as an NT service.Frans <[EMAIL PROTECTED]> wrote:
Hi Tom,Have You start Ipc-daemon before initdb ?-- Best Regards,Frans
Hi Tom,
Have You start Ipc-daemon before initdb ?
--
Best Regards,
Frans
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Fuat Atabey <[EMAIL PROTECTED]> writes:
> [macbruegge65:~/Applications/pgsql] atabey% bin/initdb -D data
> ...
> creating template1 database in data/base/1... bin/initdb: line 582:
> 7349 Abort trap "$PGPATH"/postgres -boot -x1 $PGSQL_OPT
> $BACKEND_TALK_ARG template1
> initdb fa
[EMAIL PROTECTED] writes:
> So I've been trying to upgrade to 7.3.
> The installation package ran fine. However, when I ran the initdb
> command, it failed.
It looks like the package you are using expects libcrypto version 0.9,
and you have either no libcrypto or a different version installed.
I
Joerg Brandt <[EMAIL PROTECTED]> writes:
> FATAL 1: cannot open pg_class: No such file or directory
Curious. Looking back at your previous trace, I realize that
the first invocation of postgres -boot (which should have created
pg_class) produced no debugging output except for the XLOG startup
m
> Joerg Brandt <[EMAIL PROTECTED]> writes:
> > Is the following a bug or my mistake -- any hints?
>
> Looks like a problem all right ... which PG version is this exactly?
Sorry, i forgot. postgresql version is 7.1.1, configure options are:
--prefix=/opt/pgsql
--with-tcl
--with-openssl=/usr/lib/ss
Joerg Brandt <[EMAIL PROTECTED]> writes:
> Is the following a bug or my mistake -- any hints?
Looks like a problem all right ... which PG version is this exactly?
>> Initializing pg_shadow.
> initdb failed.
> Removing temp file /tmp/initdb.11243.
Unfortunately initdb shoves all the output from
Jan,
thanks a lot!
I will look into that later, when I have more time. Maybe I will come back to
you if I have questions, or get some results.
Have a nice weekend!
Michael
On 26-Mar-99 Jan Wieck wrote:
>>
>>
>> When I just start it:
>> postgres@hobbes:/usr/local/pgsql > pg_id
>>
>
>
> When I just start it:
> postgres@hobbes:/usr/local/pgsql > pg_id
> 26
>
> It tells me I can use a parameter:
> postgres@hobbes:/usr/local/pgsql > pg_id -?
> pg_id: invalid option -- ?
> usage: pg_id [login]
>
> But when I do it, the following happens
> postgres@hobbes:/usr/local/
When I just start it:
postgres@hobbes:/usr/local/pgsql > pg_id
26
It tells me I can use a parameter:
postgres@hobbes:/usr/local/pgsql > pg_id -?
pg_id: invalid option -- ?
usage: pg_id [login]
But when I do it, the following happens
postgres@hobbes:/usr/local/pgsql > pg_id pos
Jan,
thank you for your quick answer!
Yes, I ran ldconfig after installing postgres and the path is in ld.so.conf.
So I`m still clueless!
Michael
On 26-Mar-99 Jan Wieck wrote:
>> But initdb stops with the following message:
>>
>> [...]
>>
>> This happens despite the fact, that pg_id i
>
>
> Jan,
>
> thank you for your quick answer!
>
> Yes, I ran ldconfig after installing postgres and the path is in ld.so.conf.
> So I`m still clueless!
>
> Michael
>
What happens if you run pg_id from the commandline?
Jan
--
#=
> But initdb stops with the following message:
>
> [...]
>
> This happens despite the fact, that pg_id is in the path and the shared
> libraries are set up properly.
For 6.4 the version number of libpq.so changed. Did you run
ldconfig AFTER the "make install" for postgres and is the
23 matches
Mail list logo
