Tag Info

New answers tagged

2

PostgreSQL does not support triggers on system tables, so there's no way you can write a normal trigger that fires when table definitions are changed. PostgreSQL 9.4 introduces a new feature called event triggers. (More options have been added for event triggers in the coming 9.5 release too). You could use an event trigger to validate that table ...


1

You have to configure the following two files pg_hba.conf host all all 0.0.0.0/0 md5 postgresql.conf listen_addresses='*' Make sure to restart postgres service after changing the files. You have to check if the port 5432 is open: http://www.yougetsignal.com/tools/open-ports/ If it's not then add a rule to your iptables: iptables -A INPUT -s 0/0 -p ...


0

Based on the first error message, the .gz backup file seems to be truncated. This could be confirmed with the command: gunzip -c my_db_dump.sql.gz >/dev/null Presumably this will lead to the same error message: unexpected end of file which is the root cause, the other error from postgres being the consequence of the abrupt end of the data stream. If ...


1

I just ran into the same issue on Postgres 8.3.11. Although I could not identify the root cause, the fix was simple enough: REINDEX INDEX tbl_cust_id_idx; This page contains hints as to what may have caused the error, although they are vague: An indicated table index was corrupted (may be a result of recent postgres or system failure, there was a lack ...



Top 50 recent answers are included