>
> From the docs:
>
>
> -C
> --create
>
>Begin the output with a command to create the database itself and
> reconnect to the created database. (With a script of this form, it
> doesn't matter which database you connect to before running the script.)
>
>This option is only meaningful for
On 06/10/2008 16:12, Alain Roger wrote:
> AFAIK, pg_dump -v -o -U username -ci -Ft -f tarname.tar dbname
> backup the DB but without inserting code to create the BD itself... just
What's -ci? Looking at the docs, there's are -c and -i options, but I
don't see -ci.
> how can i do that automatical
On Mon, Oct 6, 2008 at 9:12 AM, Alain Roger <[EMAIL PROTECTED]> wrote:
>
> AFAIK, pg_dump -v -o -U username -ci -Ft -f tarname.tar dbname
> backup the DB but without inserting code to create the BD itself... just to
> create its structure and populate it.
> noting about create database dbname
> gra
On Mon, Oct 6, 2008 at 3:12 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 06/10/2008 14:03, Alain Roger wrote:
> > this is basically what i use but it does not work.
> >
> > pg_restore -C -d sewe survey.tar -U postgres
>
> Just a guess, since I haven't used pg_restore - a quick look at
On 06/10/2008 14:03, Alain Roger wrote:
> this is basically what i use but it does not work.
>
> pg_restore -C -d sewe survey.tar -U postgres
Just a guess, since I haven't used pg_restore - a quick look at the docs
suggests that the filename should come *last* on the command line, so
try that
this is basically what i use but it does not work.
> pg_restore -C -d sewe survey.tar -U postgres
>
but i get the following error message:
pg_restore: [archiver (db)] connection to database "sewe" failed: FATAL:
> passwo
> rd authentication failed for user "raf_new"
>
where raf_new is my comput
On 06/10/2008 09:07, Alain Roger wrote:
> i backup my database "sewe" using a standard process.
> 1. it backups only database and not roles :-( roles are backuped separately.
> 2. backup is a tar file
> 3. backup command is : pg_dump -v -o -U myuser -ci -Ft -f sewe.tar sewe
>
> Question
> how can
Alain Roger wrote:
> i backup my database "sewe" using a standard process.
> 1. it backups only database and not roles :-( roles are backuped separately.
> 2. backup is a tar file
> 3. backup command is : pg_dump -v -o -U myuser -ci -Ft -f sewe.tar sewe
>
> Question
> how can i restore it now ?
>
2008/10/6 Alain Roger <[EMAIL PROTECTED]>:
> Hi,
>
> i backup my database "sewe" using a standard process.
> 1. it backups only database and not roles :-( roles are backuped separately.
> 2. backup is a tar file
> 3. backup command is : pg_dump -v -o -U myuser -ci -Ft -f sewe.tar sewe
You know wha
