Вопрос по postgresql, sql – Как восстановить файл дампа PostgreSQL в базы данных Postgres?

44

Error: User Rate Limit Exceeded.SQLError: User Rate Limit ExceededError: User Rate Limit ExceededError: User Rate Limit Exceeded.backupError: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Edit

Error: User Rate Limit Exceeded

newTestDB-# \i E:\db-rbl-restore-20120511_Dump-20120514.sql

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

      List of tablespaces
Name       |  Owner   | Location
-----------+----------+----------
pg_default | postgres |
pg_global  | postgres |

(2 rows)

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded\dt+Error: User Rate Limit Exceeded\dbError: User Rate Limit Exceeded dschulz
Error: User Rate Limit Exceeded\ Error: User Rate Limit ExceededpsqlError: User Rate Limit Exceeded\?. dschulz
Error: User Rate Limit Exceededhere dschulz

Ваш Ответ

7   ответов
0

22

psql

newTestDB-# /i E:\db-rbl-restore-20120511_Dump-20120514.sql   # incorrect
newTestDB-# \i E:/db-rbl-restore-20120511_Dump-20120514.sql   # correct

psql\ipsql\db\dbpsqltable spacesList of tablespaces

psqlfilepath

pgAdmin.backuppgAdminpsql \i

Error: User Rate Limit ExceededpsqlError: User Rate Limit ExceededpsqlError: User Rate Limit ExceededFILENAMEError: User Rate Limit Exceeded
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded
0

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -U postgres
psql (9.2.4)
Type "help" for help.

postgres=# \i c:\temp\try1.sql    
c:: Permission denied
postgres=# \i c:/temp/try1.sql
CREATE TABLE
postgres=#

\ibothpsql.exe

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -U postgres -f c:\TEMP\try1.sql
CREATE TABLE

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -U postgres -f c:/TEMP/try1.sql
CREATE TABLE

C:\Program Files\PostgreSQL\9.2\bin>
5

postgres=# \i driveletter:/folder_path/backupfilename.backup

postgres=#

7

1.open the terminal.

2.backup your database with following command

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

3.restore mydb.backup file into destination.

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

create database for restore the backup.

Error: User Rate Limit Exceeded

restore the backup.

Error: User Rate Limit Exceeded

46

Usually with the psql tool.

pg_dumppg_dump--clean--schema-only--inserts

psql:

psql (connection options here) database  < yourbackup.sql

psql

psql (connection options here) database
database=# \i /path/to/yourbackup.sql

pg_dump -Fcpg_restore

man psql
man pg_dump
man pg_restore

Error: User Rate Limit Exceeded Usman
Error: User Rate Limit Exceeded Usman
Error: User Rate Limit Exceeded
Error: User Rate Limit Exceeded Usman
Error: User Rate Limit Exceeded
15

pg_restore

sudo su postgres

createdb [database name] -O [owner]

createdb test_db [-O openerp]

pg_restore -d [Database Name] [path of dump file]

pg_restore -d test_db /home/sagar/Download/sample_dbump

Remember that dump file should have read, write, execute access, so for that you can apply chmod command

Похожие вопросы