> -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
Hi All;
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.
We did this:
1) installed (via source
And here are the logs
2007-11-08 15:25:39.493 DEBUG: invoking IpcMemoryCreate(size=67633152)
2007-11-08 15:25:39.493 DEBUG: mapped win32 error code 161 to 2
2007-11-08 15:25:39.493 FATAL: could not create shared memory segment:
No such file or directory
2007-11-08 15:25:39.493 DETAI
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
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/local/pgsql/data
...
selecting default max_connections... 10
selecting default shared_buffers... 50
creating configuration files... ok
creating template1 database in /usr/
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
Hi All,
Just installed PostgreSQL 7.4.5 with Cigwin and get the output copied below when running initdb.
Thanks in advance for any help.
Tom
$ initdb -dRunning in debug mode.
initdb: internal variables: PGDATA=/usr/share/postgresql/data datadir=/usr/share/postgresql PGPATH=/usr/bin ENCODING= E
Hi,
We are trying to install PostgreSql-7.4.2 on HPUX 11.23i. after installation
initdb fails with the following error message.
dome % ./bin/initdb -D /xxx/postgresql-7.4.2/data
./bin/initdb[127]: 1588 Killed
./bin/initdb[131]: 1589 Killed
./bin/initdb[136]: 1590 Killed
The program
/xxx/post
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
Hello,
i installed postgre 7.3.3. I used the Installation Instruction of
postgre.org. The installation ran fine. However, when I ran the initdb
command, it failed. The latest Apple Security Updates are installed. I
changed the prefix to a local user account, because i have no admin
rights.
I've had PostgreSQL 7.1.3 running (Mac OS X) for a while. I recently
upgraded to MAC OS X 10.2 (and it appeared that my 7.1.3 install of
PostgreSQL no longer works). So I've been trying to upgrade to 7.3.
The installation package ran fine. However, when I ran the initdb
command, it failed.
[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
I've had PostgreSQL 7.1.3 running (Mac OS X) for a while. I recently upgraded to MAC
OS X 10.2 (and it appeared that my 7.1.3 install of PostgreSQL no longer works). So
I've been trying to upgrade to 7.3. The installation package ran fine. However, when
I ran the initdb command, it failed.
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
Is the following a bug or my mistake -- any hints?
The system:
$ uname -a
SunOS euklid 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-4
The user:
$ id
uid=440(postgres) gid=177(postgres)
The problem:
$ initdb -D /export/home/data/postgres -d
Running with debug mode on.
Initdb variables:
PGDATA
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
Hi!
I just tried to upgrade to version 6.4.2. I followed the instruction and
compiling and installing went fine.
But initdb stops with the following message:
postgres@hobbes:/usr/local/pgsql > initdb -d
Running with debug mode on.
initdb: using /usr/local/pgsql/lib/local1_template1.bki.sour
33 matches
Mail list logo
