Message-ID: <50E9D507.7040506@consistentstate.com>
Date: Sun, 06 Jan 2013 12:48:23 -0700
From: CS DBA <cs_dba@consistentstate.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8;
	rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: restoring from a dump
References: <E8FDFB478C244E18ACA2B509B6CF1726@RC201204>
In-Reply-To: <E8FDFB478C244E18ACA2B509B6CF1726@RC201204>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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