Archive for the ‘Uncategorized’ Category

parallel pg_dump pg_restore JOBS

26 septiembre, 2017 Deja un comentario


Chequeo Mail Server


Easy way to view postgresql dump files

If the dump is not plain text – try using pg_restore -l your_db_dump.file command. It will list all objects in the database dump (like tables, indexes …).

Another possible way (may not work, haven’t tried it) is to grep through the output of pg_restore your_db_dump.file command. If I understood correctly the manual – the output of pg_restore is just a sequence of SQL queries, that will rebuild the db.

Categorías:BBDD, postgresql, Uncategorized

LOG pg_dump

pg_dump.exe -h my_host -p my_port -U my_user -w -Fc -b -v -f  C:\testbackup
postgres >>C:\testlog.txt 2>>C:\testlog.txt

PostgreSQL Examples to Install, Create DB & Table, Insert & Select Records

The release of the GeoDatabase is either invalid or out of date


Got this ERROR?

Failed to connect to database. The release of the GeoDatabase is either invalid or out of date. DBMS table not found [ORA-00942: table or view does not exist][SDE.GDB_Release]

Geodatabase is either invalid or out of date

I got this error when I did refresh to our Oracle DB in lower environment. After several hours troubleshooting, I laid out my findings:

1. SDE.GDB_Release does not exist on both source DB and target DB.

2. Database version is current and ArcSDE as well.

3. SDE.GDB_Items doesn’t has record in target but has records in source.

Resolution:  Try to find and compare any tables under SDE schema between source and target. I fixed the error after I inserted records from source to target in SDE.GDB_items.

I hope if you are facing this similar error, you can take this post as one of your sources in troubleshooting.

Good Luck, Friends!

Ver la entrada original