I believe I have successfully set up SDE with PG, but I am receiving errors in my PG log files. I was able to create a DB, user schema, DB connection files, and I can copy data into the new DB. However, I am seeing errors in the PG log files. I am also getting errors when I sometimes try to copy feature classes or create new feature classes.
Here is a snippet of my error log:
2012-09-01 09:31:49 MDT ERROR: relation "sde.sde_layers" does not exist at character 22
2012-09-01 09:31:49 MDT STATEMENT: select count(*) from postgres.sde.sde_layers
I thought my errors might be tied to grant privileges, but I have granted the user with grant privileges so writing to the table logs was allowed. The sde.sde_layers table exists in the SDE schema.
A second error that is repeated in the PG log:
ERROR: relation "sde.sde_logfiles" does not exist at character 174
2012-09-01 09:31:57 MDT STATEMENT: SELECT logfile_name, logfile_id, logfile_data_id, registration_id, flags, session_tag, column_name, logfile_data_db, logfile_data_owner, logfile_data_table FROM pr.sde.sde_logfiles WHERE flags%2 = 0
The table referenced here does not exist: pr.sde.sde_logfiles (pr is the DB name and there is also a user/schema with the same name).
A third error message:
2012-09-01 09:36:39 MDT ERROR: relation "public.geometry_columns" does not exist
2012-09-01 09:36:39 MDT STATEMENT: GRANT SELECT,INSERT,UPDATE,DELETE ON TABLE public.geometry_columns TO pr
2012-09-01 09:36:39 MDT ERROR: relation "public.spatial_ref_sys" does not exist
2012-09-01 09:36:39 MDT STATEMENT: GRANT SELECT ON TABLE public.spatial_ref_sys TO pr
A fourth error message:
When I copy feature classes to the SDE database I see the following error message.
2012-09-01 10:21:51 MDT STATEMENT: SELECT COUNT(*) FROM pr.pr.rpts_aoi10_250m_usaea83 WHERE shape IS NOT NULL
2012-09-01 10:23:20 MDT ERROR: index "r8_sde_rowid_uk" does not exist
2012-09-01 10:23:20 MDT STATEMENT: drop index pr.r8_sde_rowid_uk
2012-09-01 10:23:20 MDT ERROR: function pr.pr.i8_get_ids(integer, integer) does not exist at character 8
2012-09-01 10:23:20 MDT HINT: No function matches the given name and argument types. You might need to add explicit type casts.
I cannot figure out the problem, and I am guessing I have not configured something correctly. I am not extremely experienced with administering SDE, but I have been doing this for 9.3 and 10.0 and I did not have any problems.
Any thoughts/help are greatly appreciated.
TIA,
mike
