oh yeah i forgot to show you that it's linked successfully:
# sudo ldd /home/`whoami`/Software/PostgreSQL-9/bin/* | grep ssl
libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00cc4000)
libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00214000)
libssl.so.0.9.8 => /lib
On Thu, 2010-03-18 at 21:23 -0400, Vitaly Burshteyn wrote:
> Host key verification failed.
>
> I know there is nothing wrong with my host key as I can move between
> the servers with out any issues.
Host key != ssh key.
You can easily reproduce this issue by trying to ssh from master to
slave ser
Hi, i had the same problem building using latest cvs, it works fine on
64-bit ubuntu, but on 32-bit ubuntu (virtualbox) when i started the
postgres it shows:
# idir=/home/`whoami`/Software/PostgreSQL-9
# sudo su -p postgres -c "$idir/bin/postgres -D $idir/data" ;
LOG: SSL is not supported by this b
Ho folks,
Was wandering if anybody can point me in the right direction. I am
using walmgr to move WAL files from primary to stand by server.
And I keep getting this in my log files:
rsync: connection unexpectedly closed (0 bytes received so far) [sender]
rsync error: error in rsync
"Abraham, Danny" wrote:
> procpid |current_query
>
-+-
>25936 | in transaction <== This is the locker
> - What exactly is the locker doing?
At the time you ran that, it wasn't doin
=?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= writes:
> In fact what was failing was the creation of operators || and @@. Both used
> the procedures concat, exectsq and rexectsq. So we can delete those operator
> creation sentences.
Actually, it sounds to me like you might want to think about installi
Thank you, Tom.
In fact what was failing was the creation of operators || and @@. Both used the
procedures concat, exectsq and rexectsq. So we can delete those operator
creation sentences.
- Mensaje original -
De: "Tom Lane"
Para: "Iñigo Martinez Lasala"
CC: "pgsql-admin"
Enviados: J
Hi,
A process hangs forever.
When using this query...
SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s
where pg_stat_get_backend_activity(s.backendid) not like
=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala writes:
> We have adapted our schema in order to use tsearch2 from contrib folder
> for not having to rewrite all functions. We have cleaned most of old
> tsearch2 stuff, but some tsearch2 functions have dissapeared or at least
> we don't know how to invoke
Hi everybody.
We are trying to migrate a gforge (again) with postgres 8.1/2 to
postgres 8.4.
We have adapted our schema in order to use tsearch2 from contrib folder
for not having to rewrite all functions. We have cleaned most of old
tsearch2 stuff, but some tsearch2 functions have dissapeared or
"Campbell, Lance" writes:
> How do you tell pg_dump to use SSL when loading data from one server
> into another server?
It will likely do so by default, but if you want to be sure you can do
export PGSSLMODE=require
before starting pg_dump. See
http://www.postgresql.org/docs/8.4/static/
PostgreSQL 8.4.3
Assume you have two servers running PostgreSQL with SSL on.
How do you tell pg_dump to use SSL when loading data from one server
into another server?
Thanks,
Lance Campbell
Software Architect/DBA/Project Manager
Web Services at Public Affairs
217-333-0382
On Tue, 2010-03-16 at 10:05 +, Renato Oliveira wrote:
> I have been testing PITR and I have noticed a 20% increase on the load of the
> Disk subsystem.
>
> Is that a normal thing to expect? Have you come across this or have you
> noticed this increase?
>
> I know some of you guys have been
On Mon, 2010-03-15 at 13:20 -0500, Scott Whitney wrote:
> My problem is that each Saturday at midnight, I have to start a
> vacuumdb -f -z -a or my pg_clog dir never clears out.
Why is your pg_clog dir a problem?
> So, my questions are:
>
> a) Is the manual vacuum needed for performance reasons
On Wed, 2010-03-17 at 10:41 -0400, Vitaly Burshteyn wrote:
> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop?
When you say "infinite" do you mean to say it never comes out of the
loop at all? Not sure if you are reporting a bug, or not.
15 matches
Mail list logo
