Re: pg_resetxlog defect with relative database path

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: pg_resetxlog defect with relative database path
Дата
Msg-id CAHGQGwH79k2HT7YCNXnw0cwmk8bykZpTwShicJ1m4y0De+ud5Q@mail.gmail.com
обсуждение исходный текст
Ответ на PQconninfo function for libpq  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
On Thu, Nov 22, 2012 at 10:22 PM, Hari Babu <haribabu.kommi@huawei.com> wrote:
>
> When I was testing pg_resetxlog with relative database path,
> The pg_resetxlog is doing the transaction log reset even when the server is
> running.
>
> Steps to reproduce:
>         1. ./pg_ctl -D ../../data start
>         2. ./pg_resetxlog -f ../../data  -- is not able to detect as server
> is already running.
>
>
> Please find the patch for the same:
>
> *** a/src/bin/pg_resetxlog/pg_resetxlog.c
> --- b/src/bin/pg_resetxlog/pg_resetxlog.c
> ***************
> *** 254,260 **** main(int argc, char *argv[])
>            */
>           snprintf(path, MAXPGPATH, "%s/postmaster.pid", DataDir);
>
> !         if ((fd = open(path, O_RDONLY, 0)) < 0)
>           {
>                   if (errno != ENOENT)
>                   {
> --- 254,260 ----
>            */
>           snprintf(path, MAXPGPATH, "%s/postmaster.pid", DataDir);
>
> !         if ((fd = open("postmaster.pid", O_RDONLY, 0)) < 0)
>           {
>                   if (errno != ENOENT)
>                   {
>
> Any suggestions/comments?

Looks good to me.

Regards,

-- 
Fujii Masao



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

Предыдущее
От: Hari Babu
Дата:
Сообщение: pg_resetxlog defect with relative database path
Следующее
От: Tom Lane
Дата:
Сообщение: Re: MySQL search query is not executing in Postgres DB