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 the docs > suggests that the filename should come *last* on the command line, so > try that. > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > [EMAIL PROTECTED] > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > 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 grant. ... how can i do that automatically ? i mean when i dump my db, how can i dump ALSO the script to create the BD and its property ? thx.
