Hi,
On Sat, Feb 28, 2009 at 1:01 PM, wrote:
> Hi L:sters,
>
> We're at postgresql 8.2.5. I'm running PITR backups on our production server
> and copying the resulting tarball and the WAL logs to our reporting server.
> I restart the reporting server and begin re-playing logs. Everything
> work
Bryan Keith wrote:
Is the package postgresql-8.2 still installed?
I don't know. Maybe not. How can I tell?
Try
dpkg --list 'postgres*'
You'll see several packages - the first column will tell you the status
of the package. (There's a key at the top of the output.)
--
Daniel J. S
>
> Is the package postgresql-8.2 still installed?
I don't know. Maybe not. How can I tell?
> Or did the Ubuntu upgrade
> automatically deinstall that? What does the log in
> /var/log/postgresql/8.2/... say?
The last lines of the latest non-empty 8.2 log file are:
$ sudo tail -n 15 /var/log/p
Hi Bryan,
Bryan Keith wrote:
> After thinking about this a little more, I realize that the problem for me
> is not that the upgrade didn't go well. It's that I can't access my data
> on 8.2.
Well, yeah, if your Postgres 8.2 doesn't even start up, you cannot dump
the data from it. And pg_upgradec
Thomas Pundt writes:
> Lukas schrieb:
>>> I am trying to run PostgreSQL with SSL, so I compiled and
>>> linked with
>>> options:
>>> ./configure --prefix=/DB --with-openssl
> well, probably; in a situation like this I'd first check for any errors
> from the configure step.
Yeah. I would say thi
>> On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
>> wrote:
>>>
>>> The command you're looking for is pg_upgradecluster. There's a
>>> description
>>> of it at
>>> http://manpages.ubuntu.com/manpages/hardy/man8/pg_upgradecluster.8.html
>>> . I
>>> believe the only time you'll need this is if y
Lukas schrieb:
nope, no use of it.. Situation stays the same.. Does any one have more
ideas?
[...]
I am trying to run PostgreSQL with SSL, so I compiled and
linked with
options:
./configure --prefix=/DB --with-openssl
Configured and installed successfully.
In postgresql.conf I have option "
have you generated the ssl certificates too?
--- On Sun, 1/3/09, Lukas wrote:
> From: Lukas
> Subject: Re: [ADMIN] Postgesql and SSL
> To: pgsql-admin@postgresql.org
> Date: Sunday, 1 March, 2009, 8:37 AM
> Hello again,
>
> nope, no use of it.. Situation stays the same.. Does any
> one have
Hello again,
nope, no use of it.. Situation stays the same.. Does any one have more
ideas?
--
Lukas
UAB nSoft
http://www.nsoft.lt
Lukas at nsoft.lt
+370 655 10 655
> You defo have all the required openssl headers and libs and configure
> succeeds? It's a longshot, but I wonder if the prefix i
