Re: running pg_dump from python

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: running pg_dump from python
Дата
Msg-id h1ijbb$hl5$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на running pg_dump from python  (Garry Saddington <garry@schoolteachers.co.uk>)
Список pgsql-general
On 2009-06-18, Erik Jones <ejones@engineyard.com> wrote:
>
> On Jun 15, 2009, at 5:17 AM, Jasen Betts wrote:
>
>> On 2009-06-14, Garry Saddington <garry@schoolteachers.co.uk> wrote:
>>> I ahve the following python file that I am running as an external
>>> method
>>> in Zope.
>>>
>>> def backup():
>>>    import  os
>>>    os.popen("c:/scholarpack/postgres/bin/pg_dump scholarpack  >
>>> c:/scholarpack/ancillary/scholarpack.sql")
>>
>> are you sure you're using os.popen correctly?
>> you don't appear to be waiting for the pg_dump process to finish.
>
> Right, the popen stuff should be something like:
>
> p = os.popen("c:/scholarpack/postgres/bin/pg_dump scholarpack  > c:/
> scholarpack/ancillary/scholarpack.sql 2> c:/scholarpack/ancillary/
> dump.err")
>
> status = p.close()

I suspect you should also read from the handle until it returns a blocking EOF
or take some other action to ensure the process has finished before
closing the pipe.

> Then check status to see if the command was successful or not.

I suspect Garry really wanted to use os.system instead as the command
he's running is not likely to produce any data on stdout.

or perhaps he wanted to runs the command and grab stdout in the pipe...


В списке pgsql-general по дате отправления:

Предыдущее
От: Madison Kelly
Дата:
Сообщение: Re: Disaster recovery (server died)
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: looping over a small record set over and over in a function