Re: DB Install Problem

Dear all,

PostgreSQL version: 7.4.8-1
Operating system: Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
Description:
After installing the OS which includes the pg database installation, we
install our application in which we create a database - mydb - with some
tables and populate it.
(Using create database/function/table and insert commands)

The output and error stream of this installation process is redirected to
a log file.

Rarely we see that after our application installation, mydb is not present
and there is nothing Suspicious in the logfiles.

We have seen this problem in CentOS 4.4 [PostgreSQL 7.4.13-2] and RH 7.2
[PostgreSQL 7.1.3 ] also.

This happens very rarely like one in every 20 installation suffers from
this problem.

This gets resolved if on the same PC the installation is done again.

Any pointers to where the problem could be?

Thanks in advance
-S.Balaji

This doesn't look like a bug to me, and should probably be taken up
on -general or something. Nevertheless,

On Fri, Jul 06, 2007 at 12:28:59PM +0530, balajisundar(at)midascomm(dot)com wrote:
> The output and error stream of this installation process is redirected to
> a log file.

Since you don't show us any of this, it's pretty hard to know.

> Rarely we see that after our application installation, mydb is not present
> and there is nothing Suspicious in the logfiles.

Define "Suspicious". I'd be looking for an error after `initdb mydb`.
Aside from that, I'd suspect your script. It's nothing like any
actual PostgreSQL bug I've ever heard of. Also, I note that one of
your systems is Pg 7.1. Upgrade that _right now_. Don't use it.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie