John Burski writes:
> I got my postgresql build from the from a Novell SuSE Linux repository
> (mirror.susestudio.com).
> Here's the result of a run of ldd against the plperl.so file:
> linux-gate.so.1 => (0xe000)
> libperl.so => not found
File a bug with the SUSE packager.
On 03/11/2009 22:07, David Wall wrote:
> I know this used to be a problem, but I don't have a Windows server to
> test it on again.
>
> Can I do a pg_dump on Linux and then pg_restore it on Windows? We're
> using PG 8.3 now, but could certainly upgrade if that made the difference.
This should be
2009/11/4 Andre Lopes :
> Hi,
>
> I have a website using Postgres database. Now I need to develop a mobile
> website, what should I do?
You need some middleware.
As it happens, my open source project "The Karoo Project" includes
some middleware for developing websites using postgresql as the
datab
I know this used to be a problem, but I don't have a Windows server to
test it on again.
Can I do a pg_dump on Linux and then pg_restore it on Windows? We're
using PG 8.3 now, but could certainly upgrade if that made the difference.
Thanks,
David
--
Sent via pgsql-general mailing list (pgs
On Tuesday 03 November 2009 05:09:26 pm Craig Ringer wrote:
> Mike Diehl wrote:
> > It sounds to me like I've got some "stuck" connections, but I don't know
> > how to confirm this. Any other suggestions would be welcome, also.
>
> Have a look at pg_catalog.pg_stat_activity
>
> --
> Craig Ringer
On Tue, Nov 3, 2009 at 3:41 PM, JP Fletcher wrote:
> Hi,
>
> We manage hundreds of clusters and a handful of distinct pg_hba.conf files
> across several sites. We are mostly satisfied with our automated method of
> management, but on occasion, someone will hand edit a pg_hba.conf file, and
> some
Aleksey Tsalolikhin wrote:
> Hi. I just found pg_dump errors in my Apache httpd log and am really
> confused. Has anybody seen this before?
>
> My syslog.conf does not mention the httpd error_log.
>
> How did the errors get in there?
>
> # grep pg_dump /var/log/httpd/error_log
> pg_dump: [archiv
Mike Diehl wrote:
> It sounds to me like I've got some "stuck" connections, but I don't know how
> to confirm this. Any other suggestions would be welcome, also.
Have a look at pg_catalog.pg_stat_activity
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
postgres throws exceptions and outputs errors to STDERR
httpd.conf logs stderr to logs/error.log
#
# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a
# container, error messages relating to that virtual host will be
# logged here. If you *do*
Aleksey Tsalolikhin wrote:
Hi. I just found pg_dump errors in my Apache httpd log and am really
confused. Has anybody seen this before?
are you running some some of CMS or whatever that uses Postgres? Does
it have a backup feature? or phppgadmin, perhaps?
My syslog.conf does not m
David Wall wrote:
> I know this used to be a problem, but I don't have a Windows server to
> test it on again.
>
> Can I do a pg_dump on Linux and then pg_restore it on Windows? We're
> using PG 8.3 now, but could certainly upgrade if that made the difference.
Yes.
I regularly do dumps on Linux
Aleksey Tsalolikhin escribió:
> Hi. I just found pg_dump errors in my Apache httpd log and am really
> confused. Has anybody seen this before?
Somebody may have tried to abuse some PHP script or similar?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The Postgr
Thank you for your replies. We don't have a CMS and none of our PHP
scripts call pg_dump so I am concerned about the security of our
system.
On Tue, Nov 3, 2009 at 1:00 PM, Russell Smith wrote:
> Aleksey Tsalolikhin wrote:
>>
>> # grep pg_dump /var/log/httpd/error_log
>> pg_dump: [archiver] cou
Hi,
I have a website using Postgres database. Now I need to develop a mobile
website, what should I do?
Use the Postgres database or copy the information of the database to a
SQLite database? Postgres isn't heavy to a mobile website?
The website is update 2 times month. I can easly sincronize th
I know this used to be a problem, but I don't have a Windows server to
test it on again.
Can I do a pg_dump on Linux and then pg_restore it on Windows? We're
using PG 8.3 now, but could certainly upgrade if that made the
difference.
Okay, maybe I answered my own question, though if anybod
Thanks. I have ran this script and it looks like it is working.
-Original Message-
From: Raymond O'Donnell [mailto:r...@iol.ie]
Sent: Tuesday, November 03, 2009 10:51 AM
To: Arnold, Sandra
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Enabling Server Instrumentation on 8.4.1
Hi,
We manage hundreds of clusters and a handful of distinct pg_hba.conf
files across several sites. We are mostly satisfied with our automated
method of management, but on occasion, someone will hand edit a
pg_hba.conf file, and some application will get locked out. This a bad.
We'd like
On Tue, Nov 3, 2009 at 6:09 PM, Kynn Jones wrote:
> I'm trying to automate an installation of a collection of Perl modules,
> which requires determining the path to the correct libpq_fe.h file.
pkg-config should be your guy here. If it doesn't work, than find out why.
--
GJ
Hi. I just found pg_dump errors in my Apache httpd log and am really
confused. Has anybody seen this before?
My syslog.conf does not mention the httpd error_log.
How did the errors get in there?
# grep pg_dump /var/log/httpd/error_log
pg_dump: [archiver] could not open output file: Permission
On Nov 3, 2009, at 10:09 AM, Kynn Jones wrote:
I'm trying to automate an installation of a collection of Perl
modules, which requires determining the path to the correct
libpq_fe.h file.
My original implementation of the Makefile.PL file for this
installation set this path as the first v
this is somewhat related and very important for the internationalization of
postgres db
i took a look at the localisation routines and could'nt locate any
functionality to java getText(int KeyToLookup) ..no big surprise as C preceded
Java by at least 10 years
10 years ago i did a contract wh
I'm trying to automate an installation of a collection of Perl modules,
which requires determining the path to the correct libpq_fe.h file.
My original implementation of the Makefile.PL file for this installation set
this path as the first valid path that it could extract from the output of
the sy
Hi all.
I've got a database server that's been running for years now, but lately I've
had to restart it occasionally.
It seems to get slower and slower until I break down and restart it. Then it
runs well. (I vacuum regularly.)
It sounds to me like I've got some "stuck" connections, but I do
On Tue, Nov 3, 2009 at 3:29 AM, luyen dinhvan wrote:
>
> createdb: database creation failed: ERROR: encoding LATIN1 does not match
> server's locale en_US.utf8
> DETAIL: The server's LC_CTYPE setting requires encoding UTF8.
PG version? OS? Command used to attempt creation?
In later versions
>> "java.lang.Exception: DB Error: org.postgresql.util.PSQLException: An
>> I/O error
occured while sending to the backend."
This error is about the JVM has run out of all the memory that has been
allocated to it.
You can overcome this by increasing java memory parameter.
We are using pgbouncer and seeing these errors in the postgresql logs.
I don't believe pgbouncer allows for server prepared statements, so why would I
see anything in the logs at all?
2009-11-03 12:00:37 EST:u...@10.0.0.1(56270):822ERROR: prepared statement
"dbdpg_p1573_3968" does
Dear all,
I have an problems with my postgresql database. My Database is 8.2.5
and size is ~10GB with a lot of simple select,update,insert statement
using indexes.
My programs was built base on Java Environment using JDBC. In normal,
there is no problem, the program run well, all trans
createdb: database creation failed: ERROR: encoding LATIN1 does not match
server's locale en_US.utf8
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.
I wish the solution was that simple. I rent the zone and that is my
providers cap.
On 2-Nov-09, at 5:21 PM, Scott Marlowe wrote:
On Mon, Nov 2, 2009 at 1:11 PM, Brooks Lyrette > wrote:
Thanks for all the help guys.
So this is what I get from all this. My solaris zone will cap me at
around
9
Does anyone use solid state drives for postgres?
Has there been any benchmark that states whether mechanical disk drives out
perform solid state drives?
Is there any benefit, they are quite expensive.
Chris Barnes
On 03/11/2009 15:41, Arnold, Sandra wrote:
> I am in the process of trying to enable Server Instrumentation on
> Postgresql 8.4.1. I installed the software using the Linux
> one-click-installer. I have looked for the sql file that is shown on
> the screen that comes up when I try to use the Serve
I am in the process of trying to enable Server Instrumentation on Postgresql
8.4.1. I installed the software using the Linux one-click-installer. I have
looked for the sql file that is shown on the screen that comes up when I try to
use the Server Status tool in PGAdminIII (see below) but cann
On Mon, Nov 02, 2009 at 08:10:47PM -0800, Greg Stark wrote:
> As far as i know all of these actually work with doubles
> though, so you'll lose precision.
IEEE 754 floating point numbers (i.e. float8 or "double precision" in
PG) are defined to have a 52 bit significand and hence can store integer
33 matches
Mail list logo
