Спрашивает новичок, не судите строго :-)
Полный текст ошибки:
pg_dump: WARNING: out of shared memory
pg_dump: [archiver (db)] query failed: ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
pg_dump: [archiver (db)] query was: SELECT sequence_name, start_value, increment_by, CASE WHEN increment_by > 0 AND max_value = 9223372036854775807 THEN NULL WHEN increment_by < 0 AND max_value = -1 THEN NULL ELSE max_value END AS max_value, CASE WHEN increment_by > 0 AND min_value = 1 THEN NULL WHEN increment_by < 0 AND min_value = -9223372036854775807 THEN NULL ELSE min_value END AS min_value, cache_value, is_cycled FROM project_inflation_rates_id_seq

Исходные данные: Ubuntu 14.Trusty Postgresql 9.3.


Такой же результат на pg_dump mydb > Test_db.sql
Прочитал совет прописать строчку: max_locks_per_transaction = 150
Прописал ее в конец блока " RESOURCE USAGE (except WAL)" - при перезагрузке службы postgres получил ошибку.
Что не так делаю?

Настройки postgresql.conf:
# RESOURCE USAGE (except WAL)
#------------------------------------------------------------------------------

# - Memory -

shared_buffers = 1024MB # min 128kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 0 # zero disables the feature
# (change requires restart)
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
# It is not advisable to set max_prepared_transactions nonzero unless you
# actively intend to use prepared transactions.
#work_mem = 1MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 2MB # min 100kB

# - Disk -

#temp_file_limit = -1 # limits per-session temp file space
# in kB, or -1 for no limit

# - Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
# (change requires restart)
#shared_preload_libraries = '' # (change requires restart)

# - Cost-Based Vacuum Delay -

#vacuum_cost_delay = 0 # 0-100 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 1-10000 credits

# - Background Writer -

ESOURCE USAGE (except WAL)# 10-10000ms between rounds
#bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round
#bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round

# - Asynchronous Behavior -

#effective_io_concurrency = 1 # 1-1000; 0 disables prefetching

Так, открыл глаза, разглядел))
ESOURCE USAGE (except WAL)# 10-10000ms between rounds
поправил на
RESOURCE USAGE (except WAL)# 10-10000ms between rounds

По поводу этой строчки:
# per transaction slot, plus lock space (see max_locks_per_transaction).

Меняю эту строчку на нижеследующую, так?
#max_prepared_transactions = 0 # zero disables the feature
на:
#max_prepared_transactions = 150 # zero disables the feature

Разобрался, спасибо за ответы!