Re: pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jorge Alberto Fuentes Casillas <buen_sama(at)yahoo(dot)com(dot)mx>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dump
Date: 2010-09-22 22:15:04
Message-ID: 2982.1285193704@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jorge Alberto Fuentes Casillas <buen_sama(at)yahoo(dot)com(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Carel Combrink 2010-09-23 08:01:18 User access
Previous Message Mladen Gogala 2010-09-22 21:38:23 Re: Pgstatspack and pgfouine with auto_explain?