We are closing this bug report because it lacks the information we need
to investigate the problem, as described in the previous comments.
Please reopen it if you can give us the missing information, and don't
hesitate to submit bug reports in the future. To reopen the bug report
you can click on
What do these two commands show:
dpkg -l postgresql-8.3
ls -l /usr/lib/postgresql/8.3/bin
Could be file system corruption, or perhaps a full disk.
** Changed in: postgresql-8.3 (Ubuntu)
Status: New = Incomplete
--
The program postgres is needed by initdb but was not found in the
Installation had no problem until the initial db creation. Here is the
output:
** Attachment added: status of installation and files
http://launchpadlibrarian.net/25849205/pgdpkg.txt
--
The program postgres is needed by initdb but was not found in the same
directory as
This looks good, postgres is there. What is the output if you do
sudo apt-get install postgresql-8.3
now?
--
The program postgres is needed by initdb but was not found in the same
directory as /usr/lib/postgresql/8.3/bin/initdb.
https://bugs.launchpad.net/bugs/361002
You received this bug
It says that it is already installed. To reproduce the problem, I purged
postgresql-8.3 package, checked dpkg status and files under lib, tried
to install postgresql-8.3 again. The result is the same. I am also
unable to run initdb manually. You can find session log in the
attachment.
**
This is interesting:
sudo -u postgres /usr/lib/postgresql/8.3/bin/initdb -D /var/lib/postgresql -U
postgres -W
postgres (PostgreSQL) 8.3.7
fgets failure: Bad file descriptor
The program postgres is needed by initdb but was not found in the
Can you please do
strace -o /tmp/strace -vfs 1024
Hang on, I just noticed that such an strace gets about 500 MB big. After
you generated it, can you please do
tail -n 5000 /tmp/strace /tmp/strace.tail
and just attach /tmp/strace.tail?
--
The program postgres is needed by initdb but was not found in the same
directory as
It is very strance Martin,
If I collect trace, it works. For example this works:
sudo -u postgres strace -o /tmp/strace -vfs 1024
/usr/lib/postgresql/8.3/bin/initdb -D /var/lib/postgresql/main -W
However this one fails with the same error
sudo -u postgres /usr/lib/postgresql/8.3/bin/initdb
Yay for heisenbugs. However, the command is working just fine for me. I
still suspect some file system corruption.
Does it get any better after
sudo apt-get install --reinstall postgresql-8.3
?
--
The program postgres is needed by initdb but was not found in the same
directory as