On 7/15/10 2:14 PM, Tom Lane wrote:
Craig James writes:
On 8.3.10 and earlier, Postgres would ONLY load this library if we put it in
/usr/local/pgsql/lib, so I figured it was a security restriction, that Postgres
altered the LD_LIBRARY_PATH to ensure that only legitimate, admin-approved
libr
Hi all,
Today, I tried to recover a postgresql cluster (pitr). I think it went
fine (although I'm not sure), but I got some warnings afterwards...
2010-07-15 23:01:48 CEST [22907]: [2-1] user=,db= LOG: starting
archive recovery
2010-07-15 23:01:48 CEST [22907]: [3-1] user=,db= LOG:
rest
Craig James writes:
> On 8.3.10 and earlier, Postgres would ONLY load this library if we put it in
> /usr/local/pgsql/lib, so I figured it was a security restriction, that
> Postgres altered the LD_LIBRARY_PATH to ensure that only legitimate,
> admin-approved libraries could be loaded. The Pos
TIME ZONE is set to unknow in the conf file. The server syncs with NTP, has
the correct time, but there is no TMZ env variable set. I set the
recovery.conf to an hour before I want it and the logs show the time I wanted
during DST. For example if I want a PITR of 9:55 AM, I put in 8:55 AM
On 7/15/10 12:52 PM, Tom Lane wrote:
Craig James writes:
On the Postgres 8.3 system, I simply put libopenbabel.so into the
/usr/local/pgsql/lib directory, and everything worked well. On 8.4, I can't
seem to get it to load libopenbabel.so. Other programs that use this library
have no troubl
Craig James writes:
> On the Postgres 8.3 system, I simply put libopenbabel.so into the
> /usr/local/pgsql/lib directory, and everything worked well. On 8.4, I can't
> seem to get it to load libopenbabel.so. Other programs that use this library
> have no trouble finding it.
> What (if anythi
dx k9 wrote:
> Has anyone noticed that doing a PITR during DST (March-November)
> has the effect of being one ahead. Now I just adjust the
> requested time an hour earlier, but is there a better way?
I haven't noticed any odd behavior with PITR around Daylight Saving
Time boundaries. Could
Can tablespaces be defined in the postgresql.conf file? In order to encrypt or
databases we need a .decru file in $pg_data, this causes the tablespace command
to fail. Initdb fails to, but we can work around it.
Has anyone noticed that doing a PITR during DST (March-November) has the effec
On Thu, 2010-07-15 at 11:49 -0700, Craig James wrote:
> I'm migrating from Postgres 8.3.10 to 8.4.4, and also from Fedora 9 to Ubuntu
> 10.04.
>
> On 8.3.10, I have a C extension that worked on 8.3, but now refuses to load
> on 8.4:
>
> CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS i
I'm migrating from Postgres 8.3.10 to 8.4.4, and also from Fedora 9 to Ubuntu
10.04.
On 8.3.10, I have a C extension that worked on 8.3, but now refuses to load on
8.4:
CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer
AS '/usr/local/pgsql/lib/libchmoogle.so', 'chmoogle_session_
this doesn't make sense. why go through the overhead of smb to get to a
database cluster over a network connection when pg can already work over
tcpip sockets and work much more switfly on a local file system?
2010/7/15 Silvio Brandani
> Hi all,
>
> I need to start a postgres istance on a samba
Silvio Brandani writes:
> I need to start a postgres istance on a samba filesystems /data which
> have rwxrwxrwx (777) permissions, Ic ould not change such permissions.
> If I try to start postgres it complain that should be 700 permission .
> How can I skip this control by postgres startup pro
I have noticed a few threads pertaining to the "cache lookup failed"
error message, and thought I would add some data to the mix. I have
suffered this error in the past, and worked around it by dumping,
dropping and restoring my database (which is what landed me asking for
help yesterday :)). I t
Hi all,
I need to start a postgres istance on a samba filesystems /data which
have rwxrwxrwx (777) permissions, Ic ould not change such permissions.
If I try to start postgres it complain that should be 700 permission .
How can I skip this control by postgres startup process and be able to
s
Hi,
I'm trying to setup a warm standby server. But there are some things that I
don't yet understand.
I'm testing this on my windows box to understand the concepts and while waiting
for the real hardware ;)
I got the basic setup working, and a simulated failover was working, but some
things a
Hi!
Position: MySQL & PostGres DBA
Experience: 5 - 10 years +
Location: San Jose, California.
Work/Visa Permit: US Citizens, Green Card Holders & H1B.
Duration: 3 months Contract
JOB DESCRIPTION:
Responsible for planning, coordinating and administering matters related to
PostgreSQL/MySQL databas
16 matches
Mail list logo