However, I'm stuck in restoring a PostgreSQL 9.2.4 dump to PostgreSQL 9.4.5 database. I'm doing the backup using pg_dump version PostgreSQL 9.2.4 in text file (SQL dump). I'm trying to restore it to PostgreSQL 9.4.5 usng psql.
try to use 9.4.x pg_dump
Regards
Pavel
The restoration error message was as below: psql:room.sql:41695: invalid command \n Query buffer reset (cleared). psql:room.sql:41696: invalid command \n Query buffer reset (cleared).
I create the room table as below: CREATE TABLE room ( id integer NOT NULL, user_id character varying(255), partner_id character varying(255), rm_cr_ts bigint, rm_up_ts bigint, rm_sv_ts bigint, value character varying(255), last_dlvrd_to_user bigint, last_dlvrd_to_prtnr bigint, last_seen_by_user bigint, last_seen_by_prtnr bigint, num_unseen_by_user integer, num_unseen_by_prtnr integer, last_message_id integer, last_message_ts bigint, legacy_id text, legacy_last_message_id text, inserted_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL );
All the servers are Debian 7.8 (Wheezy) with hardware: - CPU 24 cores - RAM 128GB - SSD 128GB
Have anyone try this before? How to do it properly?