ArcSDE10 for PostgreSQL - Failed Post-installation on Red Hat

Question

Hello,

I'm installing ArcSDE10 for PostgreSQL on a server with Red Hat OS.
While launching the postinstallation command (sdesetup -o install...) the process fails with an error -51.

Does anyone have any suggestion for solving it? I have been thinking about file ownerships, environmental variables and I checked everything that came in my mind...

I report here the content of the sde_setup.log file:

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37  ERROR:  relation "sde.sde_layers" does not exist
LINE 1: select count(*) from drr_sde.sde.sde_layers
                             ^

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37  ERROR:  relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from drr_sde.sde.sde_server_config
                             ^

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37  ERROR:  relation "sde.sde_dbtune" does not exist
LINE 1: select count(keyword) from drr_sde.sde.sde_dbtune
                                   ^

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37  ERROR:  relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from drr_sde.sde.sde_server_config
                             ^

[Fri Jul 29 13:55:35 2011] ST_GEOMETRY support being installed...
[Fri Jul 29 13:55:35 2011] ev.SQLstate = 58P01
SDE DBMS Error: -51  ERROR:  could not access file "st_geometry": No such file or directory

[Fri Jul 29 13:55:35 2011] ST_GEOMETRY install not completed (-51).
[Fri Jul 29 13:55:35 2011] ERROR installing/upgrading ArcSDE, Error = -51

Many Thanks

Simone

VinceAngelo · Answer

Since I ran into this same error using PostgreSQL 8.3.8 with ArcSDE 10.0 SP5 on 64-bit CentOS 5.8, 
I'll provide my solution -- I updated my shell script that created tablespaces, logins, roles, schemas 
and granted permissions to include:psql -d gis100 -U sde <<EOI
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
  HANDLER plpgsql_call_handler
  VALIDATOR plpgsql_validator;
\q
EOI

(change 'gis100' to your database or a variable, of course). After that, the 'sdesetup -o install' ran 
cleanly to completion.

I didn't have the same issue with the ArcSDE 10.1 install in PostgreSQL 9.0.5, though it's uncertain 
whether this was due to the Create Enterprise Geodatabase toolbox taking care of the issue, or 
changes at 9.x that make plpgsql more generally available.

- V

NOTE: If the CREATE TRUSTED PROCEDURAL LANGUAGE above fails with 
NOTICE: using pg_pltemplate information instead of CREATE LANGUAGE parameters
try just: "CREATE LANGUAGE plpgsql;" instead.

VinceAngelo · Answer

You contact Tech Support through the mechanism prescribed by your license agreement.  For most
US sites, this is through the toll-free number; for international sites, through your local distributor. 
Most organizations with site licenses (e.g. universities) have a central tier-1/contact person who in 
turn makes the call if it's out of their league.  Evaluation installs are sometimes supported by the
local marketing office.
 
- V

simonebalbo · Answer

vangelo,

with "starting from scratch" I meant that I unistalled both arcsde and postgresql, cleaned all the dependencies and installed them again. 
I followed all the installation instructions.
The postgresql relations that I posted where created during the latest execution of "sdesetup -o install".

If nobody has any further suggestion, probably the Tech Support would be the only solution.
How can I contact it?

Thanks