pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql downgrade issue
9+ messages / 5 participants
[nested] [flat]
* postgresql downgrade issue
@ 2015-11-12 12:11 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
0 siblings, 1 reply; 9+ messages in thread
From: 許耀彰 @ 2015-11-12 12:11 UTC (permalink / raw)
To: pgsql-bugs@postgresql.org
Dear Support Team,
If we use ubuntu server to install postgresql9.4, how can we keep original
data to downgrade postgresql from 9.4 to 9.3. Would it be possible to
support the guidance for us ? Thank you.
Best Regards, Anderson Hsu
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
@ 2015-11-13 02:44 ` 张文升 <wensheng.zhang@qunar.com>
2015-11-13 02:59 ` Re: postgresql downgrade issue Jaime Casanova <jaime.casanova@2ndquadrant.com>
2015-11-13 19:30 ` Re: postgresql downgrade issue Bruce Momjian <bruce@momjian.us>
0 siblings, 2 replies; 9+ messages in thread
From: 张文升 @ 2015-11-13 02:44 UTC (permalink / raw)
To: pgsql-bugs@postgresql.org
hi~~耀彰
you can first dump data from pg9.4 use pg_dump and then restore data to
pg9.3 use pg_restore.
I hope this can help you.
On 2015年11月12日 20:11, 許耀彰 wrote:
> Dear Support Team,
> If we use ubuntu server to install postgresql9.4, how can we keep
> original data to downgrade postgresql from 9.4 to 9.3. Would it be
> possible to support the guidance for us ? Thank you.
> Best Regards, Anderson Hsu
>
> 安全提 示：本邮件非QUNAR内部邮件，请注意保护个人及公司信息安全，如有索
> 取帐号密码等可疑情况请向secteam发送邮件
>
--
----------------------
张文升
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
@ 2015-11-13 02:59 ` Jaime Casanova <jaime.casanova@2ndquadrant.com>
2015-11-13 19:53 ` Re: postgresql downgrade issue Jaime Casanova <jaime.casanova@2ndquadrant.com>
1 sibling, 1 reply; 9+ messages in thread
From: Jaime Casanova @ 2015-11-13 02:59 UTC (permalink / raw)
To: 张文升 <wensheng.zhang@qunar.com>; +Cc: pgsql-bugs@postgresql.org
On 12 November 2015 at 21:44, 张文升 <wensheng.zhang@qunar.com> wrote:
>> On 2015年11月12日 20:11, 許耀彰 wrote:
>>
>> Dear Support Team,
>> If we use ubuntu server to install postgresql9.4, how can we keep original
>> data to downgrade postgresql from 9.4 to 9.3. Would it be possible to
>> support the guidance for us ? Thank you.
>> Best Regards, Anderson Hsu
>
> hi~~耀彰
>
> you can first dump data from pg9.4 use pg_dump and then restore data to
> pg9.3 use pg_restore.
> I hope this can help you.
>
>
Actually, he should use plain text format (pg_dump default) because
PostgreSQL doesn't support downgrade.
Btw, this is not a bug. Another mailing list should have been more
appropiate, for example: pgsql-general@postgresql.org
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
2015-11-13 02:59 ` Re: postgresql downgrade issue Jaime Casanova <jaime.casanova@2ndquadrant.com>
@ 2015-11-13 19:53 ` Jaime Casanova <jaime.casanova@2ndquadrant.com>
0 siblings, 0 replies; 9+ messages in thread
From: Jaime Casanova @ 2015-11-13 19:53 UTC (permalink / raw)
To: 张文升 <wensheng.zhang@qunar.com>; 85131853@ss25.mcu.edu.tw; +Cc: pgsql-bugs@postgresql.org
On 12 November 2015 at 21:59, Jaime Casanova
<jaime.casanova@2ndquadrant.com> wrote:
> On 12 November 2015 at 21:44, 张文升 <wensheng.zhang@qunar.com> wrote:
>>> On 2015年11月12日 20:11, 許耀彰 wrote:
>>>
>>> Dear Support Team,
>>> If we use ubuntu server to install postgresql9.4, how can we keep original
>>> data to downgrade postgresql from 9.4 to 9.3. Would it be possible to
>>> support the guidance for us ? Thank you.
>>> Best Regards, Anderson Hsu
>>
>> hi~~耀彰
>>
>> you can first dump data from pg9.4 use pg_dump and then restore data to
>> pg9.3 use pg_restore.
>> I hope this can help you.
>>
>>
Actually, he should use plain text format (pg_dump default) because
PostgreSQL doesn't support downgrade.
Btw, this is not a bug. Another mailing list should have been more
appropiate, for example: pgsql-general@postgresql.org
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
@ 2015-11-13 19:30 ` Bruce Momjian <bruce@momjian.us>
2015-11-16 02:37 ` Re: [BUGS] postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
1 sibling, 1 reply; 9+ messages in thread
From: Bruce Momjian @ 2015-11-13 19:30 UTC (permalink / raw)
To: 张文升 <wensheng.zhang@qunar.com>; +Cc: pgsql-bugs@postgresql.org; 85131853@ss25.mcu.edu.tw
On Fri, Nov 13, 2015 at 10:44:07AM +0800, 张文升 wrote:
> hi~~耀彰
>
> you can first dump data from pg9.4 use pg_dump and then restore data to pg9.3
> use pg_restore.
> I hope this can help you.
The original poster was not CC'ed on the reply, so I have added him/her.
---------------------------------------------------------------------------
>
>
>
> On 2015年11月12日 20:11, 許耀彰 wrote:
>
> Dear Support Team,
> If we use ubuntu server to install postgresql9.4, how can we keep original
> data to downgrade postgresql from 9.4 to 9.3. Would it be possible to
> support the guidance for us ? Thank you.
> Best Regards, Anderson Hsu
>
>
> 安全提示：本邮件非QUNAR内部邮件，请注意保护个人及公司信息安全，如有索取帐号
> 密码等可疑情况请向 secteam发送邮件
>
>
> --
> ----------------------
> 张文升
>
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [BUGS] postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
2015-11-13 19:30 ` Re: postgresql downgrade issue Bruce Momjian <bruce@momjian.us>
@ 2015-11-16 02:37 ` 张文升 <wensheng.zhang@qunar.com>
2015-11-21 00:55 ` Re: [BUGS] postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
0 siblings, 1 reply; 9+ messages in thread
From: 张文升 @ 2015-11-16 02:37 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin; 85131853@ss25.mcu.edu.tw; jaime.casanova@2ndquadrant.com
Thank bruce and Jaime Casanova. I have moved mail to pgsql-admin.
On 2015年11月14日 03:30, Bruce Momjian wrote:
> On Fri, Nov 13, 2015 at 10:44:07AM +0800, 张文升 wrote:
>> hi~~耀彰
>>
>> you can first dump data from pg9.4 use pg_dump and then restore data to pg9.3
>> use pg_restore.
>> I hope this can help you.
> The original poster was not CC'ed on the reply, so I have added him/her.
>
> ---------------------------------------------------------------------------
>
>
>>
>>
>> On 2015年11月12日 20:11, 許耀彰 wrote:
>>
>> Dear Support Team,
>> If we use ubuntu server to install postgresql9.4, how can we keep original
>> data to downgrade postgresql from 9.4 to 9.3. Would it be possible to
>> support the guidance for us ? Thank you.
>> Best Regards, Anderson Hsu
>>
>>
>> 安全提示：本邮件非QUNAR内部邮件，请注意保护个人及公司信息安全，如有索取帐号
>> 密码等可疑情况请向 secteam发送邮件
>>
>>
>> --
>> ----------------------
>> 张文升
>>
--
----------------------
张文升 | PostgreSQL DBA
----------------------
pg开发指南 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=58058230
pg发布流程 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=56215301
pg值班列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=50508626
pg机器列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=36438672
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [BUGS] postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
2015-11-13 19:30 ` Re: postgresql downgrade issue Bruce Momjian <bruce@momjian.us>
2015-11-16 02:37 ` Re: [BUGS] postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
@ 2015-11-21 00:55 ` 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-24 12:30 ` Re: [BUGS] postgresql downgrade issue Glauco Torres <torres.glauco@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: 許耀彰 @ 2015-11-21 00:55 UTC (permalink / raw)
To: 张文升 <wensheng.zhang@qunar.com>; +Cc: Bruce Momjian <bruce@momjian.us>; pgsql-admin; jaime.casanova@2ndquadrant.com
Dear Support Team,
Thank you for your kindly assistance. How can we setup postgresql conf
file, because after we downgrade postgresql from 9.4 to 9.3, we can not
connect postgresql database from other computer? Thank you.
Best Regards, Anderson Hsu
2015-11-16 10:37 GMT+08:00 张文升 <wensheng.zhang@qunar.com>:
>
> Thank bruce and Jaime Casanova. I have moved mail to pgsql-admin.
>
> On 2015年11月14日 03:30, Bruce Momjian wrote:
> > On Fri, Nov 13, 2015 at 10:44:07AM +0800, 张文升 wrote:
> >> hi~~耀彰
> >>
> >> you can first dump data from pg9.4 use pg_dump and then restore data
> to pg9.3
> >> use pg_restore.
> >> I hope this can help you.
> > The original poster was not CC'ed on the reply, so I have added him/her.
> >
> >
> ---------------------------------------------------------------------------
> >
> >
> >>
> >>
> >> On 2015年11月12日 20:11, 許耀彰 wrote:
> >>
> >> Dear Support Team,
> >> If we use ubuntu server to install postgresql9.4, how can we keep
> original
> >> data to downgrade postgresql from 9.4 to 9.3. Would it be possible
> to
> >> support the guidance for us ? Thank you.
> >> Best Regards, Anderson Hsu
> >>
> >>
> >> 安全提示：本邮件非QUNAR内部邮件，请注意保护个人及公司信息安全，如有索取帐号
> >> 密码等可疑情况请向 secteam发送邮件
> >>
> >>
> >> --
> >> ----------------------
> >> 张文升
> >>
>
> --
> ----------------------
> 张文升 | PostgreSQL DBA
> ----------------------
> pg开发指南 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=58058230
> pg发布流程 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=56215301
> pg值班列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=50508626
> pg机器列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=36438672
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [BUGS] postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
2015-11-13 19:30 ` Re: postgresql downgrade issue Bruce Momjian <bruce@momjian.us>
2015-11-16 02:37 ` Re: [BUGS] postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
2015-11-21 00:55 ` Re: [BUGS] postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
@ 2015-11-24 12:30 ` Glauco Torres <torres.glauco@gmail.com>
2015-11-24 12:54 ` Re: [BUGS] postgresql downgrade issue Glauco Torres <torres.glauco@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Glauco Torres @ 2015-11-24 12:30 UTC (permalink / raw)
To: 許耀彰 <85131853@ss25.mcu.edu.tw>; +Cc: 张文升 <wensheng.zhang@qunar.com>; pgsql-admin
Dear Support Team,
> Thank you for your kindly assistance. How can we setup postgresql conf
> file, because after we downgrade postgresql from 9.4 to 9.3, we can not
> connect postgresql database from other computer? Thank you.
> Best Regards, Anderson Hsu
>
>
> Hello,
Check your pg_hba.conf, this probably only released to the localhost (
127.0.0.1/32).
If you want all your network can access your database add this line to your
pg_hba.conf
host all all md5 0/0 (md5, trust and password, this is who you choose)
Once add, you need to reload the postgresql service.
[1] http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
Regards,
Glauco Torres
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [BUGS] postgresql downgrade issue
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` Re: postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
2015-11-13 19:30 ` Re: postgresql downgrade issue Bruce Momjian <bruce@momjian.us>
2015-11-16 02:37 ` Re: [BUGS] postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
2015-11-21 00:55 ` Re: [BUGS] postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-24 12:30 ` Re: [BUGS] postgresql downgrade issue Glauco Torres <torres.glauco@gmail.com>
@ 2015-11-24 12:54 ` Glauco Torres <torres.glauco@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Glauco Torres @ 2015-11-24 12:54 UTC (permalink / raw)
To: 許耀彰 <85131853@ss25.mcu.edu.tw>; +Cc: 张文升 <wensheng.zhang@qunar.com>; pgsql-admin
>
>
> Dear Support Team,
>> Thank you for your kindly assistance. How can we setup postgresql conf
>> file, because after we downgrade postgresql from 9.4 to 9.3, we can not
>> connect postgresql database from other computer? Thank you.
>> Best Regards, Anderson Hsu
>>
>>
>> Hello,
>
> Check your pg_hba.conf, this probably only released to the localhost (
> 127.0.0.1/32).
>
> If you want all your network can access your database add this line to
> your pg_hba.conf
>
> host all all md5 0/0 (md5, trust and password, this is who you
> choose)
>
> Once add, you need to reload the postgresql service.
>
> [1] http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
>
>
I forgot listen_addresses the postgresql.conf parameter. If you want to
release for all connect it should be uncommented.
Like this example:
listen_addresses = '*'
If so you will need to Reboot the postgresql service
[1] http://www.postgresql.org/docs/9.4/static/runtime-config-connection.html
Regards,
Glauco Torres
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2015-11-24 12:54 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-11-12 12:11 postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-13 02:44 ` 张文升 <wensheng.zhang@qunar.com>
2015-11-13 02:59 ` Jaime Casanova <jaime.casanova@2ndquadrant.com>
2015-11-13 19:53 ` Jaime Casanova <jaime.casanova@2ndquadrant.com>
2015-11-13 19:30 ` Bruce Momjian <bruce@momjian.us>
2015-11-16 02:37 ` 张文升 <wensheng.zhang@qunar.com>
2015-11-21 00:55 ` 許耀彰 <85131853@ss25.mcu.edu.tw>
2015-11-24 12:30 ` Glauco Torres <torres.glauco@gmail.com>
2015-11-24 12:54 ` Glauco Torres <torres.glauco@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox