2009/5/14 Devrim GÜNDÜZ dev...@gunduz.org:
On Thu, 2009-05-14 at 06:51 -0700, SHARMILA JOTHIRAJAH wrote:
I'm trying to get a good postgresql book for reference. I love the
Postgresql manual but I would also like to keep a good PG book handy.
...then print PostgreSQL manual ;)
That's i call
Is there a way to read an XML file into a postgres DB? I'm thinking that it
will create and relate whatever tables are necessary to reflect whatever's
implied by the XML file structure.
Thanks for any pointers !
On Wed, May 6, 2009 at 10:47 AM, Gauthier, Dave dave.gauth...@intel.com wrote:
Is there a way to read an XML file into a postgres DB? I’m thinking that it
will create and relate whatever tables are necessary to reflect whatever’s
implied by the XML file structure.
since xml is basically
On May 6, 2009, at 10:47 AM, Gauthier, Dave wrote:
Is there a way to read an XML file into a postgres DB? I’m thinking
that it will create and relate whatever tables are necessary to
reflect whatever’s implied by the XML file structure.
There's no built-in functionality that does what
: Wednesday, May 06, 2009 11:23 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] XML - PG ?
On Wed, May 6, 2009 at 10:47 AM, Gauthier, Dave dave.gauth...@intel.com wrote:
Is there a way to read an XML file into a postgres DB? I'm thinking that it
will create and relate
hello,
as a perl addict I am... I recommend checking this out:
http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm
it's pretty flexible and allows you to specify to some extent just how
the database structure is infered from the XML...
check it out
Joao
On Wed, 2009-05-06
On Wed, 2009-05-06 at 16:53 +0100, Joao Ferreira gmail wrote:
hello,
as a perl addict I am... I recommend checking this out:
http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm
it's pretty flexible and allows you to specify to some extent just how
the database structure
Gauthier, Dave, 06.05.2009 17:40:
Maybe...
ALL
EMPLOYEES
EMP EMP_NAME=JOE JOB=CARPENTER /
EMP EMP_NAME=FRANK JOB=PLUMBER/
EMP EMP_NAME=SUE JOB=CARPENTER/
/EMPLOYEES
JOBS
JOB JOB_NAME=CARPENTER SALARY=25.50 /
JOB JOB_NAME=PLUMBER SALARY=28.75 /
/JOBS
/ALL
On Wed, 2009-05-06 at 16:53 +0100, Joao Ferreira gmail wrote:
hello,
as a perl addict I am... I recommend checking this out:
http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm
it's pretty flexible and allows you to specify to some extent just how
the database structure
Gauthier, Dave wrote:
Is there a way to read an XML file into a postgres DB? I’m thinking
that it will create and relate whatever tables are necessary to
reflect whatever’s implied by the XML file structure.
Thanks for any pointers !
That's a pretty common problem, and not one that
Gauthier, Dave wrote:
Is there a way to read an XML file into a postgres DB? I’m thinking
that it will create and relate whatever tables are necessary to
reflect whatever’s implied by the XML file structure.
Thanks for any pointers !
As others have said, the fundamental problem is that
On May 6, 2009, at 4:16 PM, Eric Schwarzenbach wrote:
Gauthier, Dave wrote:
Is there a way to read an XML file into a postgres DB? I’m thinking
that it will create and relate whatever tables are necessary to
reflect whatever’s implied by the XML file structure.
Thanks for any pointers !
I even wrote down the password when I installed the DB and now it doesn't
work!
I have logged in once to the DB through pgAdmin, and choose to store the
password and it said that it was stored in plain text.. where can I find it?
in what file?? I even created a DB that I haven't used yet so I am
On Wed, Apr 1, 2009 at 3:16 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
I even wrote down the password when I installed the DB and now it doesn't
work!
I have logged in once to the DB through pgAdmin, and choose to store the
password and it said that it was stored in plain text.. where
On 01/04/2009 20:16, Jennifer Trey wrote:
Most importantly, where can I find the password if it was stored?
It's in a file called pgpass.conf - on Windows, this is stored in the
Application Data\postgresql directory under your profile.
Ray.
Yes, I found it.. but I cannot log in?
Is there any simple way just to scratch the server and add a new one? thru
pgAdmin please?
I tried to Add Server but it requires a password too!? and thats not
working either.. why does a new server require a new password?
To Raymonds last,
I am using
...
and also, I found it (the password) but I cannot log in with it anyway...
/ Jennifer
-- Forwarded message --
From: Jennifer Trey jennifer.t...@gmail.com
Date: Wed, Apr 1, 2009 at 10:47 PM
Subject: [GENERAL] Installed PG with pgAdmin, some days later, now my
password don't work
in with it anyway...
/ Jennifer
-- Forwarded message --
From: Jennifer Trey jennifer.t...@gmail.com
Date: Wed, Apr 1, 2009 at 10:47 PM
Subject: [GENERAL] Installed PG with pgAdmin, some days later, now my
password don't work!
To: pgsql-general@postgresql.org
Yes, I found it.. but I
On 01/04/2009 20:52, Jennifer Trey wrote:
By the way, yesterday I used the TuningWizard too, could it have changed
some of these things? It does create a new config file.. is it possible?
On Wed, Apr 1, 2009 at 10:50 PM, Jennifer Trey jennifer.t...@gmail.comwrote:
Sorry, for the
Subject: [GENERAL] Installed PG with pgAdmin, some days later, now my
password don't work!
To: pgsql-general@postgresql.org
Yes, I found it.. but I cannot log in?
Is there any simple way just to scratch the server and add a new one? thru
pgAdmin please?
I tried to Add Server but it requires
Thomas Kellerer wrote:
I'm getting a new notebook and want to confirm that my idea
on how to move my Postgres installation will work This is a
development/test installation and not a production system, so
it doesn't need to be 100% fail safe.
Both systems are Windows XP 32bit.
My plan
Albe Laurenz, 24.03.2009 10:34:
Thomas Kellerer wrote:
I'm getting a new notebook and want to confirm that my idea
on how to move my Postgres installation will work This is a
development/test installation and not a production system, so
it doesn't need to be 100% fail safe.
Both systems are
Hi,
I'm getting a new notebook and want to confirm that my idea on how to move my
Postgres installation will work This is a development/test installation and not
a production system, so it doesn't need to be 100% fail safe.
Both systems are Windows XP 32bit.
My plan was to install the same
On Wed, Mar 18, 2009 at 3:57 PM, Greg Sabino Mullane g...@turnstep.comwrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I'm trying to use Perl's DBD::Pg module to import a file as a large
object.
For this I'm using the following:
my $oid = $dbh-func( /absolute/path/to/file,
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I'm trying to use Perl's DBD::Pg module to import a file as a large object.
For this I'm using the following:
my $oid = $dbh-func( /absolute/path/to/file, 'lo_import' );
Works fine for me. What version of DBD::Pg are you using? Try
The call is going out for PostgreSQL enthusiasts. We are seeking
volunteers to assist the PostgreSQL booth for this years Southern
California Linux Expo: http://scale7x.socallinuxexpo.org
The Exhibit hall will be open on Saturday the February 21st and Sunday
the 22nd between the hours of 10am
Sorry about the typo in the subject line.
On Fri, Jan 9, 2009 at 9:05 AM, Richard Broersma
richard.broer...@gmail.com wrote:
The call is going out for PostgreSQL enthusiasts. We are seeking
volunteers to assist the PostgreSQL booth for this years Southern
California Linux Expo:
On Fri, Nov 14, 2008 at 12:57:32PM +0800, Phoenix Kiula wrote:
1. If I have a unique index on (user_id, url_encrypted), then will
queries asking only for user_id also use this index? Or should i
simply have separate indexes on user_id and url_encrypted? I vaguely
recall reading somewhere that
8.4 seconds is a very long time to spend looking up a single record.
Is this table bloated? What does
vacuum verbose books;
say about it? Look for a line like this:
There were 243 unused item pointers
Thanks but this table books has autovac on, and it's manually
vacuumed every hour!
Thanks Tomas.
The table may still be bloated - the default autovacuum parameters may not
be agressive enough for heavily modified tables.
My autovacuum settings:
autovacuum = on
autovacuum_vacuum_cost_delay = 20
vacuum_cost_delay= 20
autovacuum_naptime
On Fri, Nov 14, 2008 at 9:22 PM, Hoover, Jeffrey [EMAIL PROTECTED] wrote:
There were 2132065 unused item pointers.
Looks to me like a large update or insert failed on this table
Thanks. So what can I do? I have reindexed all indexes already!
--
Sent via pgsql-general mailing list
Thanks Tomas.
The table may still be bloated - the default autovacuum parameters may
not
be agressive enough for heavily modified tables.
My autovacuum settings:
autovacuum = on
autovacuum_vacuum_cost_delay = 20
vacuum_cost_delay= 20
autovacuum_naptime
On Fri, Nov 14, 2008 at 12:57:32PM +0800, Phoenix Kiula wrote:
1. If I have a unique index on (user_id, url_encrypted), then will
queries asking only for user_id also use this index? Or should i
simply have separate indexes on user_id and url_encrypted? I vaguely
recall reading somewhere that
Phoenix Kiula [EMAIL PROTECTED] writes:
2. Is there a production equivalent of REINDEX? Last time I tried
CREATE INDEX CONCURRENTLY overnight, by the morning it had croaked
with these errors:
ERROR: deadlock detected
DETAIL: Process 6663 waits for ShareLock on transaction 999189656;
Hi.
I had tweaked my PG 8.2.6 with the very kind help of this list a
couple years ago. It has been working fine, until recently. Not sure
if it is after the update to 8.3 or because my DB has been growing,
but the db is very slow now and the cache doesn't seem enough.
~ free -m
total used free
On Fri, Nov 14, 2008 at 3:10 AM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Thu, Nov 13, 2008 at 11:59 AM, Phoenix Kiula [EMAIL PROTECTED] wrote:
Hi.
I had tweaked my PG 8.2.6 with the very kind help of this list a
couple years ago. It has been working fine, until recently. Not sure
if it is
On Thu, Nov 13, 2008 at 2:04 PM, Phoenix Kiula [EMAIL PROTECTED] wrote:
On Fri, Nov 14, 2008 at 3:10 AM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Thu, Nov 13, 2008 at 11:59 AM, Phoenix Kiula [EMAIL PROTECTED] wrote:
Hi.
I had tweaked my PG 8.2.6 with the very kind help of this list a
couple
Thanks Scott. Responses below.
(1) The culprit SELECT sql is (note that MYUSER in this example can
be an IP address) --
So, it can be, but might not be? Darn, If it was always an ip I'd
suggest changing types.
Yes, it can either be a registered USER ID or an IP address. I thought
of
Phoenix Kiula escribió:
Index Scan using new_idx_books_userid on books (cost=0.00..493427.14
rows=2 width=31) (actual time=0.428..8400.299 rows=1 loops=1)
Index Cond:
Scott Marlowe [EMAIL PROTECTED] writes:
On Thu, Nov 13, 2008 at 2:04 PM, Phoenix Kiula [EMAIL PROTECTED] wrote:
explain analyze SELECT alias, id, title, private_key, aliasEntered
FROM books
WHERE user_id = 'MYUSER' AND url_encrypted =
'bed59c2f2d92e306d4481a276bd8a78c4b0532d4' ;
QUERY
On Fri, Nov 14, 2008 at 10:57 AM, Tom Lane [EMAIL PROTECTED] wrote:
Yeah, but note that the planner knows darn well that this will be an
expensive query --- 493427.14 cost units estimated to fetch 2 rows!
My interpretation is that the condition on user_id is horribly
nonselective (at least
Is there a way to get the PG version string from JDBC? I'm using PG 8.3.
Thanks,
David
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Select version();
version
-
PostgreSQL 8.3.3, compiled by Visual C++ build 1400
(1 row)
On Wed, Oct 15, 2008 at 2:01 PM, David Wall [EMAIL PROTECTED] wrote:
Is there a way to get the PG version string from JDBC? I'm
David Wall wrote:
Is there a way to get the PG version string from JDBC? I'm using PG 8.3.
Thanks,
David
SELECT version() ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
David Wall wrote on 15.10.2008 23:01:
Is there a way to get the PG version string from JDBC? I'm using PG 8.3.
Thanks,
David
In a portable manner:
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getDatabaseProductName()
[EMAIL PROTECTED] writes:
we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
itself is working as expected.
...
Our problem is that DBD::Pg version 2.10.7 will not compile ,
LD_RUN_PATH=/usr/lib gcc -shared -O2 Pg.o dbdimp.o quote.o types.o
-o blib/arch/auto/DBD/Pg/Pg.so
Hello,
we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
itself is working as expected.
We are using PostreSQL via following perl version
# perl -v
This is perl, v5.10.0 built for i686-linux-thread-multi
(with 4 registered patches, see
Tapio.Niva wrote:
we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
itself is working as expected.
We are using PostreSQL via following perl version
# perl -v
This is perl, v5.10.0 built for i686-linux-thread-multi
(with 4
version 2.10.7 from CPAN.
Again, thanks for great help !
Have a nice day
BR, Tapio
-Original Message-
From: Albe Laurenz [mailto:[EMAIL PROTECTED]
Sent: 7. lokakuuta 2008 15:04
To: Niva Tapio; pgsql-general@postgresql.org
Subject: RE: [GENERAL] DBD::Pg 2.10.7 compile failed on RH4
I hope someone can urgently help. I was running 8.2.3 with a lot of
pleasure and no-nonsense. Very fast and delightful database that had
me singing paeans.
But I upgraded to 8.2.9 this morning and have had a major slowdown of
the DB processes. How do I begin to test what is going wrong?
I
On 8/28/08, Phoenix Kiula [EMAIL PROTECTED] wrote:
I hope someone can urgently help. I was running 8.2.3 with a lot of
pleasure and no-nonsense. Very fast and delightful database that had
me singing paeans.
But I upgraded to 8.2.9 this morning and have had a major slowdown of
the DB
Phoenix Kiula [EMAIL PROTECTED] schrieb:
I hope someone can urgently help. I was running 8.2.3 with a lot of
pleasure and no-nonsense. Very fast and delightful database that had
me singing paeans.
But I upgraded to 8.2.9 this morning and have had a major slowdown of
the DB processes. How
On 8/28/08, Andreas Kretschmer [EMAIL PROTECTED] wrote:
Please show us a EXPLAIN ANALYSE for this query. Btw, why
random_page_cost=2? (your other post)
The EXPLAIN ANALYZE shows that it's using an INDEX and getting one
row! So I know the SQL is right.
Could it be that the SQL queries become
On Thu, 2008-08-28 at 15:23 +0800, Phoenix Kiula wrote:
But I upgraded to 8.2.9 this morning and have had a major slowdown of
the DB processes. How do I begin to test what is going wrong?
After restart, OS and PostgreSQL caches are cleaned up -- it might also
slow down PostgreSQL a bit.
On Thu, Aug 28, 2008 at 02:44:08PM +0300, Devrim GÜNDÜZ wrote:
After restart, OS and PostgreSQL caches are cleaned up -- it might also
slow down PostgreSQL a bit.
I'll bet this is the right answer -- before, you were mostly getting
things out of cache (memory), and right now everything has to
On Sun, Jul 13, 2008 at 4:31 PM, gabrielle [EMAIL PROTECTED] wrote:
OSCON is fast approaching - just one more week!
I need some people to help out with booth staffing for Thursday. Sign up here:
http://wiki.postgresql.org/wiki/Oscon_2008_signup
Staffing the booth is a ton o' fun and a great
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Daniel Johnson
Sent: Monday, July 14, 2008 10:07 AM
To: gabrielle
Cc: [EMAIL PROTECTED];
pgsql-general@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [pdxpug] Pg booth staffing at OSCON
On Sun, Jul 13,
I'm wondering how much of the conference we have access to with an
exhibitor badge? Obviously not tutorials, but what about regular
technical sessions?
You get into the exhibit hall when it is closed to regular attendees.
You get lunch. I'm not sure that there are any perks beyond that.
--
On Feb 9, 2008, at 12:20 PM, Ken Johanson wrote:
But given the recent and dramatic example of 8.3's on-by-default
stricter typing in functions (now not-autocasting), I worry that
kind of change could happen in every minor version (8.4 etc).
You need to *know* your software if you're using
On Mon, 2008-02-11 at 09:09 +0100, Peter Eisentraut wrote:
Ken Johanson wrote:
Is there anything now, or in the works, for compatibility emulation? For
example to setup my session to act like 8.2 and allow less-strict
typing.
The best way to ensure 8.2 compatibility is to use 8.2. But
Ken Johanson wrote:
Is there anything now, or in the works, for compatibility emulation? For
example to setup my session to act like 8.2 and allow less-strict
typing.
The best way to ensure 8.2 compatibility is to use 8.2. But as casts are user
definable, you can add back any casts you want.
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Version 2.0.0 of DBD::Pg, the Perl DBI interface to Postgres, has
been released. Find it at your favorite CPAN mirror.
This is a major release, so agrressive testing and feedback is
much appreciated.
Please report any bugs here:
On Monday 11 February 2008 14:49, Jeff Davis wrote:
On Mon, 2008-02-11 at 09:09 +0100, Peter Eisentraut wrote:
Ken Johanson wrote:
Is there anything now, or in the works, for compatibility emulation?
For example to setup my session to act like 8.2 and allow less-strict
typing.
The
I noticed that, in one of the third-party databases I have installed
on my server, one foreign key constraint could not be implemented.
(The key columns are of incompatible types.) In previous upgrades I
had seen a warning concerning this constraint, and had passed this
information along
On Feb 10, 2008, at 10:44 AM, Dave Livesay wrote:
I noticed that, in one of the third-party databases I have
installed on my server, one foreign key constraint could not be
implemented. (The key columns are of incompatible types.) In
previous upgrades I had seen a warning concerning this
I acknowledge that from time to time we must accept changes in the 3rd
party software that will break our apps if we (or customers) ever
upgrade them (a compounded issue if we have heavily-used deployments in
the field and not just in-house ones to maintain).
But given the recent and dramatic
Ken,
* Ken Johanson ([EMAIL PROTECTED]) wrote:
But given the recent and dramatic example of 8.3's on-by-default stricter
typing in functions (now not-autocasting), I worry that kind of change
could happen in every minor version (8.4 etc).
8.3 isn't a minor version.
Enjoy,
Stephen Frost wrote:
* Ken Johanson ([EMAIL PROTECTED]) wrote:
But given the recent and dramatic example of 8.3's on-by-default stricter
typing in functions (now not-autocasting), I worry that kind of change
could happen in every minor version (8.4 etc).
8.3 isn't a minor version.
PG
Ken Johanson wrote:
Stephen Frost wrote:
* Ken Johanson ([EMAIL PROTECTED]) wrote:
But given the recent and dramatic example of 8.3's on-by-default
stricter typing in functions (now not-autocasting), I worry that kind
of change could happen in every minor version (8.4 etc).
8.3 isn't a
Magnus Hagander wrote:
PG uses a different versioning system than this one?:
http://en.wikipedia.org/wiki/Software_versioning#Numeric
Or do you mean the changes are not minor? :-)
Yes, we use the one stated on our site, not wikipedia ;)
See: http://www.postgresql.org/support/versioning
Ken Johanson [EMAIL PROTECTED] writes:
Is there anything now, or in the works, for compatibility emulation?
Sure: keep using the same major release. This is one of the reasons
that we keep updating back release branches for so long.
regards, tom lane
On Sat, Feb 09, 2008 at 10:54:38AM -0700, Ken Johanson wrote:
Magnus Hagander wrote:
PG uses a different versioning system than this one?:
http://en.wikipedia.org/wiki/Software_versioning#Numeric
Or do you mean the changes are not minor? :-)
Yes, we use the one stated on our site, not
Ken Johanson wrote:
Magnus Hagander wrote:
PG uses a different versioning system than this one?:
http://en.wikipedia.org/wiki/Software_versioning#Numeric
Or do you mean the changes are not minor? :-)
Yes, we use the one stated on our site, not wikipedia ;)
See:
On Sat, 09 Feb 2008 10:20:51 -0700
Ken Johanson [EMAIL PROTECTED] wrote:
I acknowledge that from time to time we must accept changes in the
3rd party software that will break our apps if we (or customers) ever
upgrade them (a compounded issue if we have heavily-used deployments
in the field
Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
use Getopt::Std;
So I assume it's not getting past the use Pg line as although it's
looking in /usr/lib/perl5 it's not going to look in
/usr/lib/perl5/DBD ??
DBD::Pg is not the
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
I wouldn't trust that library or anything that depends on it if I were
you. It's been unmaintained for a *very* long time.
Cheers,
David.
Hi chaps,
Excellent, it was libpg-perl I needed.
Thanks
--- Richard Huxton [EMAIL PROTECTED] wrote:
Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
use Getopt::Std;
So I assume it's not getting past the use Pg line
On 29 Jan 2008, at 13:39, Martijn van Oosterhout wrote:
On Tue, Jan 29, 2008 at 01:30:04PM +, adam_pgsql wrote:
this looks to be using the Pg module rather than DBI + DBD::Pg. This
one i think:
http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz
i think thats quite old
Colin Wetherbee wrote:
CaT wrote:
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
...
So I assume it's not getting past the use Pg line as although it's
looking in /usr/lib/perl5 it's not
On Tue, Jan 29, 2008 at 04:45:48AM -0800, Glyn Astill wrote:
Should the subdirectory DBD be in there? Perl was setup using apt.
How are you using it and what's your DBI db connect line?
I'm about to go to sleep so if I don't reply it'll be because I'm
unconcious. :)
--
To the extent that
Run perl -V and see if the path is there for @INC. If it's there,
check
such things as permissions. If not, ponder deeply as to why this is
so
(as /usr/lib/perl5 is a standard path for perl in /usr) and if you
can't
fix it 'properly' you can work-around with the use of 'use lib'
(see
On Tue, Jan 29, 2008 at 04:24:05AM -0800, Glyn Astill wrote:
I'm trying yo run a perl script that uses DBI (Slonys
psql_replication_check.pl to be precise) and I'm getting the error:
Can't locate Pg.pm in @INC
Now I do have the file in /usr/lib/perl5/DBD/ but the script can't
see it. I'm
CaT wrote:
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
...
So I assume it's not getting past the use Pg line as although it's
looking in /usr/lib/perl5 it's not going to look in
On Tue, Jan 29, 2008 at 04:24:05AM -0800, Glyn Astill wrote:
Hi chaps,
I'm trying yo run a perl script that uses DBI (Slonys
psql_replication_check.pl to be precise) and I'm getting the error:
Can't locate Pg.pm in @INC
Pg.pm isn't DBI. It's the Pg Perl interface.
A
Hi chaps,
I'm trying yo run a perl script that uses DBI (Slonys
psql_replication_check.pl to be precise) and I'm getting the error:
Can't locate Pg.pm in @INC
Now I do have the file in /usr/lib/perl5/DBD/ but the script can't
see it. I'm guessing that unless I fudge it and put the absoloute
On Tue, Jan 29, 2008 at 08:14:28AM -0800, David Fetter wrote:
I wouldn't trust that library or anything that depends on it if I were
you. It's been unmaintained for a *very* long time.
Because code rusts when it's sitting around on a hard drive?
Pg.pm doesn't get much attention, I agree,
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
use Getopt::Std;
our ($opt_h, $opt_d, $opt_p, $opt_U, $opt_w, $opt_c) = '';
my ($conn, $res, $status, @tuple);
my $query = 'SELECT * FROM replication_status' ;
my @rep_time;
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
...
So I assume it's not getting past the use Pg line as although it's
looking in /usr/lib/perl5 it's not going to look in
this looks to be using the Pg module rather than DBI + DBD::Pg. This
one i think:
http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz
i think thats quite old now though
On 29 Jan 2008, at 13:10, Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which
adam_pgsql wrote:
this looks to be using the Pg module rather than DBI + DBD::Pg. This one
i think:
http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz
i think thats quite old now though
Indeed, that's how it looks. That would be in the libpg-perl package on
Debian. In
On Tue, Jan 29, 2008 at 01:30:04PM +, adam_pgsql wrote:
this looks to be using the Pg module rather than DBI + DBD::Pg. This
one i think:
http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz
i think thats quite old now though
In the one in this package:
On Jan 29, 2008, at 1:07 PM, Andrew Sullivan wrote:
On Tue, Jan 29, 2008 at 08:14:28AM -0800, David Fetter wrote:
I wouldn't trust that library or anything that depends on it if I
were
you. It's been unmaintained for a *very* long time.
Because code rusts when it's sitting around on a
On Jan 29, 2008, at 7:24 AM, Glyn Astill wrote:
I'm trying yo run a perl script that uses DBI (Slonys
psql_replication_check.pl to be precise) and I'm getting the error:
Can't locate Pg.pm in @INC
It doesn't use DBI, it uses Pg. At some point I posted patches to
convert it to DBI and
David Fetter wrote:
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote:
well its using the pgsql_replication_check.pl, which does:
--
use Pg;
I wouldn't trust that library or anything that depends on it if I were
you. It's been unmaintained for a *very* long
On Tue, Jan 29, 2008 at 01:56:35PM -0500, A.M. wrote:
The postgresql from eight years ago is also quite rusty.
No, it's not, which is my point. If you don't need any of the features you
mention, and are aware of the limitations, there's nothing wrong with
using it. The v2 protocol works, for
On Jan 29, 2008, at 2:36 PM, Andrew Sullivan wrote:
On Tue, Jan 29, 2008 at 01:56:35PM -0500, A.M. wrote:
The postgresql from eight years ago is also quite rusty.
No, it's not, which is my point. If you don't need any of the
features you
mention, and are aware of the limitations,
On Tue, Jan 29, 2008 at 03:16:41PM -0500, A.M. wrote:
...and Pg.pm includes a serious security hole in the form of non-
existent query escaping which will never be fixed. Are we really
discussing the semantics of rust?
It has never done that escaping. No rust has occurred. This is a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 29 Jan 2008 18:36:02 -0800
Reece Hart [EMAIL PROTECTED] wrote:
I'm guessing lack of maintenance... the SFPUG hasn't maintained David
for a very long time. We think he lives at Casa Donde, but no one is
really sure where that is.
I
On Tue, 2008-01-29 at 13:28 -0500, Geoffrey wrote:
Are you speaking from personal experience, or just of the lack of
maintenance?
I'm guessing lack of maintenance... the SFPUG hasn't maintained David
for a very long time. We think he lives at Casa Donde, but no one is
really sure where that
Alright, reading the file in
postgresql-8.2.5/src/timezone/README
I take it that anyone with a source compiled pg or using source rpms
should be able to download the tzdata from here:
ftp://elsie.nci.nih.gov/pub/tzcode2007k.tar.gz
and put it here:
postgresql-8.2.5/src/timezone/data
and
201 - 300 of 436 matches
Mail list logo