pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: restoring from a dump
Date: Mon, 7 Jan 2013 13:11:19 +0000
Message-ID: <77F5F8FA4B407F43BFCFD3FC347896913CC16D@COVMSGCES-MBX01> (raw)
In-Reply-To: <50E9D507.7040506@consistentstate.com>
References: <E8FDFB478C244E18ACA2B509B6CF1726@RC201204>
	<50E9D507.7040506@consistentstate.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

The other quick item to consider is whether or not your database is on a *nix system or a windows machine, and if your workstation is *nix or windows.  

Cases/suggestions:
1. Windows workstation / *nix DB Server: use putty.exe to ssh into the DB server (a second option would be to use PGAdmin, a GUI db management package for PostgreSQL)
2. Windows workstation / Windows DB Server: use CMD.com and enter psql command line (may have to add "C:/Program Files/PostgreSQLX.YY/bin" to your PATH).  Could also use PGAdmin in this case
3. *nix client / *nix server: command line psql (ssh to server if not the same as your workstation)



________________________________________
From: pgsql-admin-owner@postgresql.org [pgsql-admin-owner@postgresql.org] on behalf of CS DBA [cs_dba@consistentstate.com]
Sent: Sunday, January 06, 2013 2:48 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] restoring from a dump

On 1/5/13 1:54 PM, J Rouse wrote:
> Stupid person here.  Just got PostgresSQL today.  Have text dump
> file.  Need to restore.
>
> I think I need to use psql, but do not even know how to get to it.
> Need exact instructions on where to enter the command line, setting up
> paths if necessary, etc.
>
> Jim
>
>
>
to restore from a text (sql) file:

1) ensure you have a target database:
- you might need to set your path, i.e. you need to know where psql is
- if you did an rpm / package install it's probably in /usr/bin

# connect to the cluster (database instance):
$ psql

# then create your target database:
postgres# create database my_target_db;

Then exit from psql (exit; or ctl-d)
postgres# exit;



2) import the sql text file

- cd to the directory where the text file is:
$ cd /home/postgres/Downloads

- Import the file
$ psql  -ef   ./import_file.sql   my_target_db


You could also point to the sql file without being in the directory:
$ psql  -ef   /home/postgres/Downloads/import_file.sql my_target_db



Note the -f is the psql flag to import (or run) a specified sql file
from the command line, the -e flag says to push all SQL statements as
well as normal output to STDOUT


See the psql command docs for more info here:

http://www.postgresql.org/docs/9.2/interactive/app-psql.html



Hope this helps,

/Kevin







--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (3+ messages)

Message-ID: <77F5F8FA4B407F43BFCFD3FC347896913CC16D@COVMSGCES-MBX01>
Permalink:  ../77F5F8FA4B407F43BFCFD3FC347896913CC16D@COVMSGCES-MBX01/
Also on:    postgresql.org/message-id/77F5F8FA4B407F43BFCFD3FC347896913CC16D@COVMSGCES-MBX01

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Robert.Burgholzer@deq.virginia.gov
  Subject: Re: restoring from a dump
  In-Reply-To: <77F5F8FA4B407F43BFCFD3FC347896913CC16D@COVMSGCES-MBX01>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox