Gentoo Archives: gentoo-user

From: covici@××××××××××.com
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] how to upgrade postgresql under gentoo
Date: Mon, 10 Nov 2014 12:59:33
Message-Id: 18342.1415624362@ccs.covici.com
In Reply to: Re: [gentoo-user] how to upgrade postgresql under gentoo by Vladimir Romanov
1 Well, I found the old binaries in my backups and did the deed, the only
2 problems, was that the old data directory did not contain any .conf
3 files, so I copied the new ones into the old data directory and it was
4 then happy. I m not sure what happened to the .conf files in the old
5 data directory, but they had not been there for quite a while, so maybe
6 this was a problem with the arlier beta. Very strange but it looks
7 good.
8
9 Thanks for your help.
10
11 Vladimir Romanov <blueboar2@×××××.com> wrote:
12
13 > Well... then we need someone, who is more professional, since AFAIK
14 > multiple postgresql's can be on one system in several slots. Maybe (as it
15 > is beta, slots are the same, therefore new deletes old and vice versa)?
16 >
17 > 2014-11-10 16:47 GMT+05:00 <covici@××××××××××.com>:
18 >
19 > > What it does then is delete the beta3 and give me only beta2. This is
20 > > what I had done to fix my original problem, I can show you the build log
21 > > for beta3 if that would help. I am using gentoo-unstable, but that
22 > > should be obvious.
23 > >
24 > > Vladimir Romanov <blueboar2@×××××.com> wrote:
25 > >
26 > > > You updated your beta2 with beta3. Now you can add beta2 again by emerge
27 > > > =dev-db/posgresql-9.4-beta2 (or something like)
28 > > >
29 > > > 2014-11-10 16:36 GMT+05:00 <covici@××××××××××.com>:
30 > > >
31 > > > > Well, after the emerge, no sign of beta2 anywhere, I have the directory
32 > > > > /usr/lib64/postgresql-9.4/ with the beta3 binaries and that is all, is
33 > > > > there a problem with the ebuilds or something?
34 > > > >
35 > > > > Vladimir Romanov <blueboar2@×××××.com> wrote:
36 > > > >
37 > > > > > Well, emerge it again :). You can have two postgresql-servers in
38 > > > > different
39 > > > > > slots.
40 > > > > >
41 > > > > > 2014-11-10 16:21 GMT+05:00 <covici@××××××××××.com>:
42 > > > > >
43 > > > > > > However, when I emerge beta3, beta2 is gone, so this is my problem.
44 > > > > > >
45 > > > > > >
46 > > > > > > Vladimir Romanov <blueboar2@×××××.com> wrote:
47 > > > > > >
48 > > > > > > > Yes. You emerge both beta2 and beta3, then run pg_upgrade for
49 > > beta3,
50 > > > > > > > provide BOTH binaries to it, it converts the base. Then you can
51 > > > > delete
52 > > > > > > > beta2.
53 > > > > > > >
54 > > > > > > > 2014-11-10 16:04 GMT+05:00 <covici@××××××××××.com>:
55 > > > > > > >
56 > > > > > > > > Hi. I have a puzzle regarding upgrading postgresql. In my
57 > > recent
58 > > > > > > world
59 > > > > > > > > update I went from 9.4_beta2 to beta3, but when I tried to
60 > > start
61 > > > > the
62 > > > > > > > > server, it complained that the databases were written with a
63 > > > > different
64 > > > > > > > > "catalog version" -- whatever that is, and the pg_upgrade tool
65 > > > > requires
66 > > > > > > > > both old and new binaries to actually upgrade the database.
67 > > So as
68 > > > > a
69 > > > > > > > > temporary measure, I went back to beta2 and things worked
70 > > again.
71 > > > > So
72 > > > > > > > > what the heck are you supposed to do here, I like pg, but this
73 > > is
74 > > > > very
75 > > > > > > > > strange to me.
76 > > > > > > > >
77 > > > > > > > > Thanks in advance for any suggestions.
78 > > > > > > > >
79 > > > > > > > > --
80 > > > > > > > > Your life is like a penny. You're going to lose it. The
81 > > question
82 > > > > is:
83 > > > > > > > > How do
84 > > > > > > > > you spend it?
85 > > > > > > > >
86 > > > > > > > > John Covici
87 > > > > > > > > covici@××××××××××.com
88 > > > > > > > >
89 > > > > > > > >
90 > > > > > > >
91 > > > > > > > ----------------------------------------------------
92 > > > > > > > Alternatives:
93 > > > > > > >
94 > > > > > > > ----------------------------------------------------
95 > > > > > >
96 > > > > > > --
97 > > > > > > Your life is like a penny. You're going to lose it. The question
98 > > is:
99 > > > > > > How do
100 > > > > > > you spend it?
101 > > > > > >
102 > > > > > > John Covici
103 > > > > > > covici@××××××××××.com
104 > > > > > >
105 > > > > > >
106 > > > > >
107 > > > > > ----------------------------------------------------
108 > > > > > Alternatives:
109 > > > > >
110 > > > > > ----------------------------------------------------
111 > > > >
112 > > > > --
113 > > > > Your life is like a penny. You're going to lose it. The question is:
114 > > > > How do
115 > > > > you spend it?
116 > > > >
117 > > > > John Covici
118 > > > > covici@××××××××××.com
119 > > > >
120 > > > >
121 > > >
122 > > > ----------------------------------------------------
123 > > > Alternatives:
124 > > >
125 > > > ----------------------------------------------------
126 > >
127 > > --
128 > > Your life is like a penny. You're going to lose it. The question is:
129 > > How do
130 > > you spend it?
131 > >
132 > > John Covici
133 > > covici@××××××××××.com
134 > >
135 > >
136 >
137 > ----------------------------------------------------
138 > Alternatives:
139 >
140 > ----------------------------------------------------
141
142 --
143 Your life is like a penny. You're going to lose it. The question is:
144 How do
145 you spend it?
146
147 John Covici
148 covici@××××××××××.com

Replies

Subject Author
Re: [gentoo-user] how to upgrade postgresql under gentoo Vladimir Romanov <blueboar2@×××××.com>