Hi,
On Fri, 2006-03-24 at 01:16 -0600, Clyde Swann wrote:
> running fedora 2... just installed postgresql 7.4.12 from postgresql
> website because the version that came with fedora core 2 did not have
> the pg_config in postgres-devel. now this one does not either. what
> gives?
Fedora Core 2
Clyde Swann wrote:
> supposed to be. searched the web (google) and everyone says the same
> thing, install postgres-devel. it is not working.
I'm sure they said install postgresql-devel.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)-
running fedora 2... just installed postgresql 7.4.12 from postgresql website because the version that came with fedora core 2 did not have the pg_config in postgres-devel. now this one does not either. what gives? where do i find pg_config. i have applications and perl modules that will n
Just Someone wrote:
[snip]
>>
>> mke2fs -b $bsizeb -j -J size=400 -m 1 -O sparse_super \
>> -T largefile4 -E stride=$stride /dev/sdb
>>
>> Mounted with: mount -t ext3 -o data=journal,noatime /dev/sdb /mnt/test8
>
> That's an interesting thing to try, though because of other things I
> want, I pre
Steve Atkins <[EMAIL PROTECTED]> writes:
> I'm doing some reporting-type work with PG, with the vast
> majority of queries hitting upwards of 25% of the table, so
> being executed as seq scans.
> ...
> It would be really nice to be able to do all the work with a
> single pass over the table, execut
""Merlin Moncure"" <[EMAIL PROTECTED]> wrote
>
> In postgresql, queries executed over the parameterized/prepared C api
> are particularly fast...as much as a 70% speed reduction over vanilla
> PQexec.
Does it mean 70% time is spent on planning? I am a little bit interested in
this number. Can you
Chris Travers wrote:
Recently I have been attempting to install Compiere. After spending a
lot of time attempting to get it to work, I have given up installing
it on PostgreSQL. I did however, get a little experience installing
JDBC and PL/Java in the mean time.
I discovered in the process
I'm doing some reporting-type work with PG, with the vast
majority of queries hitting upwards of 25% of the table, so
being executed as seq scans.
It's a fairly large set of data, so each pass is taking quite
a while, IO limited. And I'm looking at doing dozens of
passes.
It would be really nice
I played a bit with kernnel versions as I was getting a kernel panic
on my Adaptec card. I downgraded to 2.6.11 (the original that came
with fedora core 4) and the panic went away, but more than that, the
performance on XFS went considerably higher. With the exact same
settings as before, I got now
Steve Crawford wrote:
We have a dedicated PostgreSQL server but a variety of client machines
ranging from soon to be retired SCO 5.0.x to SuSE 10.
What is the recommended method to build/install/deploy only the
client-side libraries and utilities (psql, pg_dump, etc.) and not the
server?
We
Recently I have been attempting to install Compiere. After spending a
lot of time attempting to get it to work, I have given up installing it
on PostgreSQL. I did however, get a little experience installing JDBC
and PL/Java in the mean time.
I discovered in the process of attempting to insta
On Thursday 23 March 2006 17:46, David Fetter wrote:
> On Thu, Mar 23, 2006 at 04:46:02PM -0500, Robert Treat wrote:
> > > ...and it's unlikely that they will, now or later, without
> > > somebody whose whole job is to monitor those comments and make
> > > patches.
> >
> > Well, we do make some att
On 3/23/06, Wes <[EMAIL PROTECTED]> wrote:
> This keeps the indexes a more or less reasonable size, and allows quick
> deleting of the old data. Is there any problem with 180 child tables? How
> many would be too many (e.g. if I did one table per 6 hours?)
I am not a guru. Many, many people on
Hi,
> Did you re-initialize the test pgbench database between runs?
> I get weird results otherwise since some integers gets overflowed in the
> test (it doesn't complete the full 1 transactions after the first run).
No, I didn't. The reason is that I noticed that the first run is
always MUCH
I'm working on a database that will (at current load) add 100 million
records per day to a database, and needs to keep around 6 months of data
online. Of course, we don't want the loads to be running all day while
queries are going on.
Using COPY with indexes active runs great with an empty datab
We have a dedicated PostgreSQL server but a variety of client machines
ranging from soon to be retired SCO 5.0.x to SuSE 10.
What is the recommended method to build/install/deploy only the
client-side libraries and utilities (psql, pg_dump, etc.) and not the
server?
We have a development box
My quick-n-dirty "fix" is to make symbolic links in /usr/bin for all pg
programs:
But, as I noted, only after you are sure you have removed all vestiges
of the old version. The symbolic links are just a convenience.
The *right* solution if you're using an RPM-based Linux distro is to
grab an
On Thu, Mar 23, 2006 at 04:46:02PM -0500, Robert Treat wrote:
> > ...and it's unlikely that they will, now or later, without
> > somebody whose whole job is to monitor those comments and make
> > patches.
>
> Well, we do make some attempt at rolling comments into the docs
> where appropriate, but
Steve Crawford <[EMAIL PROTECTED]> writes:
> Brian Kitzberger wrote:
>> It worked fine. I was able to create a database from a DDL I wrote and
>> do insert into the tables and selects with correct results. So I was
>> testing the pg_dump with I ran into problems.
> And had you run /usr/local/pgs
Brian Kitzberger wrote:
Steve,
You asked how I built the my install of 8.1.3. With the tar files at
the root, I used the gunzip and tar commands from the web site on the
base, docs, opt, and test tar files as suggested by the PostgreSQL.org
web site, which made the postgresql-8.1.3 directory.
On Thu, 2006-03-23 at 15:32, Brian Kitzberger wrote:
> Steve,
>
> Okay, not only am I new to PostgreSQL but I am new to Linux with a
> little experience years ago with Unix. So I didn't know about rpm nor
> does any one else here. But anyway, the result of running rpm is:
Hey, we all started so
On Thu, 2006-03-23 at 15:19, Bjørn T Johansen wrote:
> On Thu, 23 Mar 2006 15:01:17 -0600
> Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
> > >
> > > If I try the same from a client, I get the same result.. But when running
> > > from my webapp (using
> > > Hibernate), only question marks appear...
Steve,
You asked how I built the my install of 8.1.3. With the tar files at
the root, I used the gunzip and tar commands from the web site on the
base, docs, opt, and test tar files as suggested by the PostgreSQL.org
web site, which made the postgresql-8.1.3 directory. I then did the
steps sugge
On Thursday 23 March 2006 15:12, David Fetter wrote:
> On Thu, Mar 23, 2006 at 07:00:13PM +0100, Jim Nasby wrote:
> > On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote:
> > >I just discovered that the comments from 8.0 had the answer I was
> > >looking for but these comments are not in the 8.1 docs. S
On March 23, 2006 01:32 pm, "Brian Kitzberger"
<[EMAIL PROTECTED]> wrote:
> Steve,
>
> Okay, not only am I new to PostgreSQL but I am new to Linux with a
> little experience years ago with Unix. So I didn't know about rpm nor
> does any one else here. But anyway, the result of running rpm is:
>
Steve,
Okay, not only am I new to PostgreSQL but I am new to Linux with a
little experience years ago with Unix. So I didn't know about rpm nor
does any one else here. But anyway, the result of running rpm is:
postgresql-libs-7.4.8-0.6
postgresql-server-7.4.8-0.6
postgresql-jdbc-7.3-189.1
postg
Hi,
I'm having an issue using NULL values to fill placeholders in a
prepared SELECT statement. My table looks something like this:
CREATE TABLE person (id serial primary key, lname text not null, fname text);
Given queries like this (using the Perl DBI+DBD::Pg interface):
$i = $db->prepare('IN
On Thu, 23 Mar 2006 15:01:17 -0600
Scott Marlowe <[EMAIL PROTECTED]> wrote:
> >
> > If I try the same from a client, I get the same result.. But when running
> > from my webapp (using
> > Hibernate), only question marks appear?
>
> Again, I'm pretty sure this is a known issue with the JDBC
> Neil Conway wrote:
> There is no such thing as "PG 8.3".
I meant 8.1.3
> please provide the queries that trigger the problem and the
> relevant schema definitions.
Sorry about not posting more details initially. I was running out the
door and was hasty.
> Try re-running ANALYZE and retryi
[EMAIL PROTECTED] (Scott Marlowe) writes:
> http://bugs.mysql.com/bug.php?id=13301
And as Heikki Tuuri is no longer with them, I'll bet that doesn't get
changed any time soon...
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/finances.html
On Thu, 2006-03-23 at 14:50, Bjørn T Johansen wrote:
> On Thu, 23 Mar 2006 17:21:38 +0100
> Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
>
> > Bjørn T Johansen <[EMAIL PROTECTED]> schrieb:
> > > > Set in your postgresql.conf:
> > > >
> > > > log_statement = all
> > > >
> > > > Since 8.0 oder 8.
Brian Kitzberger wrote:
Hi Steve,
pg_dump --versionreturned 7.4.8
pg_dumpall --version returned 7.4.8
psql *version returned 7.4.8
which pg_dump returned /usr/bin/pg_dump
which pg_dumpall returned /usr/bin/pg_dump
which psql returned /usr/bin/psql
To find the file I used from the root
On Thu, 23 Mar 2006 17:21:38 +0100
Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
> Bjørn T Johansen <[EMAIL PROTECTED]> schrieb:
> > > Set in your postgresql.conf:
> > >
> > > log_statement = all
> > >
> > > Since 8.0 oder 8.1, there you can see parameters in prepared statements.
> > >
> > >
>
On Thu, Mar 23, 2006 at 03:31:42PM -0500, Oisin Glynn wrote:
> I am a Windows only developer (for my sins) and to be honest we are
> using postgres allot and are impressed by it but the *NIX centric
> examples in the docs can sometimes be a challenge, if there is a clear
> difference between Win
Scott Marlowe wrote:
On Thu, 2006-03-23 at 14:12, David Fetter wrote:
On Thu, Mar 23, 2006 at 07:00:13PM +0100, Jim Nasby wrote:
On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote:
I just discovered that the comments from 8.0 had the answer I was
looking for but these comments are
On Thu, 2006-03-23 at 14:12, David Fetter wrote:
> On Thu, Mar 23, 2006 at 07:00:13PM +0100, Jim Nasby wrote:
> > On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote:
> >
> > >I just discovered that the comments from 8.0 had the answer I was
> > >looking for but these comments are not in the 8.1 docs
On Thu, Mar 23, 2006 at 07:00:13PM +0100, Jim Nasby wrote:
> On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote:
>
> >I just discovered that the comments from 8.0 had the answer I was
> >looking for but these comments are not in the 8.1 docs. Should the
> >comments be rolled forward as new version
On Thu, 2006-03-23 at 13:03, Brian Kitzberger wrote:
> Hi Tom,
>
> I decided to test your theory that I had an old version of Postgres on
> my system when I installed version 8.1.3. By the way, the Linux install
> we a fresh one to start with. So this morning I first did a search on
OK, assumin
"Brian Kitzberger" <[EMAIL PROTECTED]> writes:
> which pg_dump returned /usr/bin/pg_dump
> which pg_dumpall returned /usr/bin/pg_dump
> which psql returned /usr/bin/psql
Didn't you say that you had installed PG 8.1.3 in a separate directory
tree (something about postgresql-8.1.3)? Maybe your
Jim,
I did another test with ext3 using data=writeback, and indeed it's much better:
Avg:429.87
Stdev: 77
A bit (very tiny bit) faster than xfs and bit slower than jfs. Still,
very much improved.
Bye,
Guy.
On 3/23/06, Jim Nasby <[EMAIL PROTECTED]> wrote:
> On Mar 23, 2006, at 11:32 AM,
Hi Steve,
pg_dump --versionreturned 7.4.8
pg_dumpall --version returned 7.4.8
psql *version returned 7.4.8
which pg_dump returned /usr/bin/pg_dump
which pg_dumpall returned /usr/bin/pg_dump
which psql returned /usr/bin/psql
To find the file I used from the root
find . -name pg_dump
I
Brian Kitzberger wrote:
Hi Tom,
I decided to test your theory that I had an old version of Postgres on
my system when I installed version 8.1.3. By the way, the Linux install
we a fresh one to start with. So this morning I first did a search on
my system for all pg_dump files, and wrote the lo
Hi Tom,
I decided to test your theory that I had an old version of Postgres on
my system when I installed version 8.1.3. By the way, the Linux install
we a fresh one to start with. So this morning I first did a search on
my system for all pg_dump files, and wrote the locations down. I them
remo
I find that my killed connection server process process disappear in Status
after a long time.
> If pgAdmin's cancel is just dropping the connection, the server might
> take some time to notice it, especially if it's in the process of running
> a query and doesn't have reason to talk to pgAdmi
On Thu, 2006-03-23 at 12:17, Jim Nasby wrote:
> On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
> > Now, I shouldn't be able to insert anything in b that's not
> > referencing
> > an entry in a. and I used innodb tables. and I used ansi SQL, and I
> > got no errors. So how come my data's in
On Mar 22, 2006, at 10:08 PM, Scott Marlowe wrote:
Now, I shouldn't be able to insert anything in b that's not
referencing
an entry in a. and I used innodb tables. and I used ansi SQL, and I
got no errors. So how come my data's incoherent three seconds after
creating the tables the way the s
>
> Hello there,
> I'm a freelance Oracle Developer by trade (can almost hear the boos now
> ;o)), and am looking into developing my own Snowboarding-related
> website over the next few years. Anyway, I'm making some decisions now
> about the site architecture, and the database I'm going to need is
>As I'm sure you've asked the same question of the MySQL folks, can you tell
>us what they've said about "us"? I guess it's not just idle curiosity (90%
>though), but it might give us some pointers about how to improve either our
>marketing, implementation or both.
Not yet asked them, but will pop
Hi James :
I am mysql user for 5 years. An a this time i am trying to go out from
mysql.
What i am living mysql?
Becouse my php bases systems require some features that mysql is
inplementing in the vercion 5.0, like store procedures and functions,
trrigers, transaction, views, and some others fea
On Mar 23, 2006, at 9:50 AM, [EMAIL PROTECTED] wrote:
I currently use phpPgAdmin to make changes to the database, so it
would
be very handy if Postgres could add a change made to a lable
somewhere,
after which I gather all the rows with changes and put them in a SQL
query.
My suggestion: d
On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote:
I just discovered that the comments from 8.0 had the answer I was
looking for but these comments are not in the 8.1 docs. Should the
comments be rolled forward as new versions are created? Or if valid
comments added to the docs themselves?
h
On Mar 23, 2006, at 11:01 AM, Just Someone wrote:
I was doing some load testing on a server, and decided to test it with
different file systems to see how it reacts to load/speed. I tested
xfs, jfs and ext3. The machine runs FC4 with the latest 2.6.15 kernel
from Fedora.
You should also try te
On Mar 23, 2006, at 11:32 AM, Bernhard Weisshuhn wrote:
Just Someone wrote:
2 10K SCSI disks in RAID1 for OS and WAL (with it's own partiton on
ext3),
You'll want the WAL on its own spindle. IIRC a separate partition
on a shared disc won't give you much benefit. The idea is to keep
the d
On Mar 23, 2006, at 3:33 AM, Steven Brown wrote:
-- On INSERT, fill id from the sequence - creator has UPDATE
permission.
-- Block attempts to force the id.
CREATE OR REPLACE FUNCTION foo_id_insert_procedure() RETURNS
trigger SECURITY DEFINER AS '
BEGIN
IF NEW.id != 0 THEN
RAISE
On Mar 22, 2006, at 9:21 PM, Jeff Amiel wrote:
We have a fairly 'good' process at our shop that we follow that
works for us
First we do a schema comparison between our prod and devl/test
environments using the EMS PostgreSQL database comparer tool...
Another way to handle this is to
On Mar 22, 2006, at 7:14 PM, Andrus wrote:
Do you mean that the statement hadn't been fully transmitted yet?
Yes. Sending 2 MB takes most of time so client is terminated in
this stage.
If so, the backend would have just been waiting for the rest of the
statement to arrive. Perhaps you'r
Include a "Limit" in your query.
Michael Schmidt
"Jimbo1" <[EMAIL PROTECTED]> writes:
> Not yet asked them, but will pop the question over the next week. ;o)
Careful about "popping the question"... While good marriages have
come from that, so also have been some bad ones :-).
--
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http:/
am 23.03.2006, um 10:37:26 -0600 mailte Jim C. Nasby folgendes:
> I'm in Brussels until Wednesday; should anyone be interested in grabbing
> a beer or 3 somewhere drop me an email.
Nice idea ;-), but too far for me.
Regards, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz: 03
I'm in Brussels until Wednesday; should anyone be interested in grabbing
a beer or 3 somewhere drop me an email.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cel
Hello,
I accidentaly came across this post. I didn't follow it so I don't know whether
my posting is to the topic or not. I've just uploaded project at
SourceForge.Net on topic of PostgreSQL database schema upgrades because I
needed to find out differences between current and new schemas. The p
Bjørn T Johansen <[EMAIL PROTECTED]> schrieb:
> > Set in your postgresql.conf:
> >
> > log_statement = all
> >
> > Since 8.0 oder 8.1, there you can see parameters in prepared statements.
> >
> >
> >
> > HTH, Andreas
>
>
> This is what I am already using and it doesn't work...
It works for
On Thu, 2006-03-23 at 10:09, Bjørn T Johansen wrote:
> On Thu, 23 Mar 2006 14:25:52 +0100
> "A. Kretschmer" <[EMAIL PROTECTED]> wrote:
>
> > am 23.03.2006, um 14:07:11 +0100 mailte Bjørn T Johansen folgendes:
> > > Is it possible to log the actual statement that the server runs? At the
> > > mom
On Thu, 23 Mar 2006 14:25:52 +0100
"A. Kretschmer" <[EMAIL PROTECTED]> wrote:
> am 23.03.2006, um 14:07:11 +0100 mailte Bjørn T Johansen folgendes:
> > Is it possible to log the actual statement that the server runs? At the
> > moment, the statement that is
> > logged, is logged using ? for para
More information. I backed up a database (one that failed to backup in
8.1) from the old 8.0 system, and re-imported it into the 8.0 system
without any problem. Then I imported it into the 8.1 system without
errors, and tried to do a backup again. It failed.
So there seems to be either a flaw
I'm compiling postgresql 8.1.3 with these gcc flags: -march=pentium4 -O3
The compilation ends correctly but the interval regression test fails.
This is the diff file:
=
*** ./expected/interval.out Thu Mar 23 15:38:42 2006
I have driven myself to distraction for the last 30 minutes trying to
get COPY to work on Windows XP. The Unix style c:/afolder/afile
instead of c:\afolder\afile was a desperation attempt.
I had tried all sorts of double slashes \\ putting the whole path in
quotes basically all sorts of fool
To answer my own mail, I shut down the 8.1 database, and started up the
8.0 PostgreSQL install that is still on my computer, and the backups
work fine. I do get the message about how 8.1 handles sorting of unicode
characters more correctly, but looking at my backups, I can see that the
full bac
I have seen several people with this same error. I get mine when trying
to backup using pg_dump, causing my backups to fail.
I am using PostgreSQL 8.1 on Windows XP.The databases are in UTF8. I get
the same error from the command line and using pgadmin3.
Has anyone found a solution for this?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
am 23.03.2006, um 14:07:11 +0100 mailte Bjørn T Johansen folgendes:
> Is it possible to log the actual statement that the server runs? At the
> moment, the statement that is
> logged, is logged using ? for parameters; I would like to log the statement
> after the parameters have been
> substitut
Thanks. I'll see if I can get a scheduled maintenance check on this.The disks seem to be good as they are a 0+1 RAID and all internal tests show them to be in good health along with the controller. Would memory be a good suspect?
On 3/22/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Tass Chapman" <[EMA
Is it possible to log the actual statement that the server runs? At the moment,
the statement that is
logged, is logged using ? for parameters; I would like to log the statement
after the parameters have been
substituted, isn't this possible in 8.1.x? (used to work in 7.x.x)
Regards,
BTJ
--
Guido Neitzer wrote:
I mostly use the command line tools or a graphical tool to make my own
sql calls for every schema change I make on the development database.
Then all these changes come to a "script" in my application (it's not
actually a script but similar). The database has a version
Just Someone wrote:
2 10K SCSI disks in RAID1 for OS and WAL (with it's own partiton on
ext3),
You'll want the WAL on its own spindle. IIRC a separate partition on a
shared disc won't give you much benefit. The idea is to keep the disc's
head from moving away for other tasks. Or so they say.
Sorry. Forgot the link:
http://www.onjava.com/pub/a/onjava/2004/06/16/dbcancel.html?page=2
"William ZHANG" <[EMAIL PROTECTED]>
> Re: [GENERAL] partial resultset in javaI have not install pgsql's jdbc.
> But I think the following link may help.
>
> Regards,
> William ZHANG
>
-
Re: [GENERAL] partial resultset in javaI have not install pgsql's jdbc. But
I think the following link may help.
Regards,
William ZHANG
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgres
I was doing some load testing on a server, and decided to test it with
different file systems to see how it reacts to load/speed. I tested
xfs, jfs and ext3. The machine runs FC4 with the latest 2.6.15 kernel
from Fedora.
Hardware: Dual Opteron 246, 4GB RAM, Adaptec 2230 with battery backup,
2 10K
On 23.03.2006, at 9:50 Uhr, [EMAIL PROTECTED] wrote:
I currently use phpPgAdmin to make changes to the database, so it
would
be very handy if Postgres could add a change made to a lable
somewhere,
after which I gather all the rows with changes and put them in a SQL
query.
I mostly use the
Quoting Janning Vygen <[EMAIL PROTECTED]>:
Am Mittwoch, 22. März 2006 20:40 schrieb Luuk Jansen:
I have a problem with finding a way to update a database structure.
This might be a very simple problem, just cannot find the info.
I am looking at updating the structure of my database. I put an
a
Tom + Seneca,
Thank you for your sage advice - hopefully I will have enough Linux +
compilation experience to bridge the AIX gap - no doubt if I run into
big problems, you'll hear about it soon! :)
Cheers,
Gavin,
---(end of broadcast)---
TIP
81 matches
Mail list logo
