From: | Ilia Chipitsine <ilia(at)paramon(dot)ru> |
---|---|
To: | Najib Abi Fadel <nabifadel(at)usj(dot)edu(dot)lb> |
Cc: | generalpost <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dump in cycle |
Date: | 2004-09-16 09:01:23 |
Message-ID: | 20040916145941.L87845@office.paramon.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
yes, but how can I integrate that query with shell script (which will
perform actual dumping) ?
I would even say, "select datname from pg_database where not
datistemplate", becuase otherwise pg_dump will complain about template0
Cheers,
Ilia Chipitsine
> U can use :
> select datname from pg_database;
>
> in order to get the list of databses
>
> HTH
>
> Najib.
>
> ----- Original Message -----
> From: "Ilia Chipitsine" <ilia(at)paramon(dot)ru>
> To: "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb>
> Sent: Thursday, September 16, 2004 10:41 AM
> Subject: Re: [GENERAL] pg_dump in cycle
>
>
>>> Use pg_dump instead of pg_dumpall
>>>
>>> example:
>>> pg_dump databaseName > databaseDumpFile
>>>
>>> if u have many databases, you can make a script that dumps each database
> in
>>
>> sure, I have many databases.
>> how can I write such script without explicitly specifying database names ?
>> I do not want to modify that script after I have added database.
>>
>>> it's own file ....
>>>
>>>
>>>
>>> ----- Original Message -----
>>> From: "Ilia Chipitsine" <ilia(at)paramon(dot)ru>
>>> To: <pgsql-general(at)postgresql(dot)org>
>>> Sent: Thursday, September 16, 2004 8:08 AM
>>> Subject: [GENERAL] pg_dump in cycle
>>>
>>>
>>>> Dear Sirs,
>>>>
>>>> I want to dump all databases, but separately each database in its own
>>>> file, not all databases in one single file as pg_dumpall does.
>>>>
>>>> How can I implement that ?
>>>>
>>>> Cheers,
>>>> Ilia Chipitsine
>>>>
>>>> ---------------------------(end of
> broadcast)---------------------------
>>>> TIP 4: Don't 'kill -9' the postmaster
>>>>
>>>
>>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stefano Bonnin | 2004-09-16 09:29:57 | problem with pg_restore and user privileges |
Previous Message | Paramveer.Singh | 2004-09-16 09:00:43 | lexicographical ordering in postgres |