Re: pg_dump - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_dump
Date
Msg-id 2982.1285193704@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump  (Jorge Alberto Fuentes Casillas <buen_sama@yahoo.com.mx>)
List pgsql-novice
Jorge Alberto Fuentes Casillas <buen_sama@yahoo.com.mx> writes:
> Hello, thanks for the support, well, this is what i do:
> jfmac:~ jafc$ /Library/PostgreSQL/8.3/scripts/runpsql.sh; exit
> Server [localhost]: localhost
> Database [postgres]: gintratinylocal
> Port [5433]: 5433
> Username [postgres]: gintratinylocal
> Password for user gintratinylocal:
> Welcome to psql 8.3.10, the PostgreSQL interactive terminal.

> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit

> gintratinylocal=# pg_dump --help
> gintratinylocal-#

> it prints nothing at all.

pg_dump is a command-line program.  You should call it directly from
the shell prompt in the terminal window, not from inside psql.  Or,
if that "runpsql" script is setting up some environment for psql,
maybe what you want to do is create a similar script to execute pg_dump.

            regards, tom lane

pgsql-novice by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Pgstatspack and pgfouine with auto_explain?
Next
From: "Carel Combrink"
Date:
Subject: User access