On Tue, 2006-09-19 at 13:27, Brandon Aiken wrote:
Define 'quick'.
You could write a script that would transform a .csv file into an INSERT
statement and save it to an .sql file.
Or I suppose you could do silly ODBC stuff with MS Access.
--
Brandon Aiken
CS/IT Systems Engineer
On Wed, 2006-09-20 at 14:34 +0200, [EMAIL PROTECTED] wrote:
Hello!
We're running the latest release of PostgreSQL 7.4.13 on a Debian Sarge
machine. Postgres has been compiled by oureselves.
We have a pretty big database running on this machine, it has about 6.4 GB
approximately. One table
On Wed, 2006-09-20 at 15:14 +0200, [EMAIL PROTECTED] wrote:
Hello Scott!
Thank you for the quick answer. I'll try to check our hardware which is a
Compaq DL380 G4 with a batteyr buffered write cache on our raid controller.
As the system is running stable at all i think it's not the cpu or
On Wed, 2006-09-20 at 16:29, Johan wrote:
Hi,
I encountered a strange problem while trying to solve a bug. I use a
postgresql 8.x database and a jdbc driver from
postgresql-8.1dev-400.jdbc3.jar. The following is happening
The table is created like
create table test (
field1 int8 not
On Thu, 2006-09-21 at 08:47, Brad Nicholson wrote:
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the
On Sun, 2006-09-24 at 12:03 +0200, Ralf Wiebicke wrote:
Hi all!
I just realized the following behaviour in postgresql: when I violate any
constraint (unique constraint in my case) then the transaction is not usable
anymore. Any other sql command returns a in failed sql transaction error.
On Mon, 2006-09-25 at 16:20, Ralf Wiebicke wrote:
Hi!
Thanks for all the help.
I finally used savepoints to get what I want.
However I don't like this very much. I tried a few other databases (hsqldb,
mysql/innodb and oracle), and none of them made the transaction unusable
after
On Tue, 2006-09-26 at 23:31, deep ... wrote:
Hi all,
I'm running a web application supported by postgresql 7.4 on an unix
system. The management part of application requires reindexing of
tables. I see that whenever reindexing runs with the while the table
is getting updated/inserted into,
On Tue, 2006-09-26 at 09:19, Tom Lane wrote:
Thomas Peter [EMAIL PROTECTED] writes:
the full code that does produce the error (and this error can be resolved
as in OP described) is:
Never oversimplify a bug report.
FROM ticket as t, permission as perm, enum as p
LEFT OUTER JOIN
On Wed, 2006-09-27 at 00:22, Najib Abi Fadel wrote:
What is the problem with pg_pconnect and is pgpool easy to use with an
already running application ?
Should i expect a major performance boost ?
pg_pconnect isn't pooling per se. In pooling, a large number of
processes share a small number
On Tue, 2006-10-10 at 04:16, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/09/06 22:43, Jonathan Greenberg wrote:
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
While all the talk of a hinting system over in hackers and perform is
good, and I have a few queries that could live with a simple hint system
pop up now and again, I keep thinking that a query planner that learns
from its mistakes over time is far more desirable.
Is it reasonable or possible for
On Thu, 2006-10-12 at 17:14, Jim C. Nasby wrote:
On Thu, Oct 12, 2006 at 03:31:50PM -0500, Scott Marlowe wrote:
While all the talk of a hinting system over in hackers and perform is
good, and I have a few queries that could live with a simple hint system
pop up now and again, I keep
On Fri, 2006-10-13 at 12:48, Jim C. Nasby wrote:
On Thu, Oct 12, 2006 at 05:39:20PM -0500, Scott Marlowe wrote:
It seems to me the first logical step would be having the ability to
flip a switch and when the postmaster hits a slow query, it saves both
the query that ran long, as well
On Thu, 2006-11-09 at 06:07, Sandeep Kumar Jakkaraju wrote:
Hi All ..
I have used Oracle 9i in the past ...currently working on postgres ...
Oracle throws this SQLException ... Too many open cursors
when there are too many connections to the database.
That may be the exception
On Sat, 2006-11-11 at 19:15, novnov wrote:
I agree with what you say. And I'd still be interesting in hearing of first
hand experience with the speed of the two databases from someone who is
'good' at both. The article commentor was obviously not a pgsql expert. I've
heard recently that pgsql
On Mon, 2006-11-13 at 15:36, novnov wrote:
OK, thanks everyone, I gather from the responses that postgres performance
won't be an issue for me then. If MS SQL Server and Postgres are in the same
ballpark performance-wise, which seems to be the upshot of your comments, no
problem. I'd only have
On Tue, 2006-11-14 at 15:04, [EMAIL PROTECTED] wrote:
Can I install a PostgreSQL DB on a Novell LAN drive or must it be on a
server?
Do you mean running postgresql on a linux or windows machine with the
$PGDATA directory located on a Novell / NFS / Samba mount, or do you
mean running
On Mon, 2006-11-27 at 10:36, Andrus wrote:
I noticed that that pgAdmin invokes pg_dump with -b command line parameter.
I havent found any documentation about this parameter in Psotgres Docs.
What is the purpose of this parameter ?
According to pg_dump --help:
-b, --blobs
On Thu, 2006-11-23 at 10:23, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/22/06 20:23, carter ck wrote:
Hi all,
I am wonderring if it is a good practice to use SERIAL index as primary
key, as it is only available up to 999?
Currently i am dealing
On Thu, 2006-11-16 at 14:56, Martijn van Oosterhout wrote:
On Thu, Nov 16, 2006 at 12:40:41PM -0800, Glen Parker wrote:
But now, pull the drive from port 2 and boot the system. You will now
have SDA,SDB,SDC. The kernel will now fail BOTH of the last two drives
from the RAID array. The
On Wed, 2006-11-29 at 10:56, Steve Poe wrote:
I need some input from the Postgresql community.
Our animal hospital runs Postgresql 7.4 on a 6-disc RAID10. The
database logs are on a separate RAID1.
We're using an LSI MegaRAID 320-2X controller. The controller reports
one 146GB SCSI disc
On Wed, 2006-11-29 at 13:21, Steve Poe wrote:
Yep, I've done it a few times. A few tips:
backup your database with pg_dump. confirm you can restore on
a test
machine.
Thanks. We do nightly dump and restore to a second server for
testing/backup
On Wed, 2006-11-29 at 14:16, Vivek Khera wrote:
On Nov 29, 2006, at 2:39 PM, Scott Marlowe wrote:
Sounds good. According to LSI, the drive will take 8 hrs to rebuild a
146GB disc (at a 30% rebuild rate), so doing this in the middle of
the
day is not ideal.
The rebuild time also
Is it possible to have each user connect via different postgresql
account? if so, then you can use
alter user set search_path='common_schema','user_schema';
where common schema has the things that would be the same for each
instance of the app, and user_schema is the name of that user's schema.
On Thu, 2006-11-30 at 13:45, John McCawley wrote:
Note that my in my current code, application-level permissions are
completely detached from database permissions. The entire web app uses
one user/pass to login to the database. The web app is used both by
individual companies who can
On Thu, 2006-11-30 at 14:07, John McCawley wrote:
Maybe I'm not understanding what you're getting at, so I'll throw out an
example:
I completely understand what you're saying, but I'm not quite getting
the reasons for it. For instance:
HOWEVER, when user big_daddy logs into the
On Mon, 2006-12-04 at 15:11, Anton Melser wrote:
Hi,
I am just starting at a company and we are inheriting a previously
built solution. It looks pretty good but my previous experience with
pg is seriously small-time compared with this...
OK, how you set up RAID depends largely on how you'll
On Mon, 2006-12-04 at 17:53, Raymond O'Donnell wrote:
On 4 Dec 2006 at 15:40, Bob Pawley wrote:
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
This is an issue which has come up at various times on this list in
the
On Tue, 2006-12-05 at 00:42, deep ... wrote:
Hi everyone,
I have a java app using pgsql 7.3 on unix platform where the latest
version of the app updates the width of a row in a table as a part of
upgrade. Since there is no straightforward 'modify' clause in
Postgresql 7.3, we're using
On Mon, 2006-12-04 at 09:56, Schwenker, Stephen wrote:
Hello,
I'm having a major Vacuuming problem. I used to do a full vacuum
every morning on my postgres database to clean up empty space on a
table but because of it's size, the locking of the database causes my
application server to max
On Tue, 2006-12-05 at 04:59, [EMAIL PROTECTED] wrote:
Hi all,
We are moving from MySQL to PgSQL in my organization and I would like
some input on what the best method is for working with one development
and one live database. We need to copy all data, structure information,
functions et.c.
I'm pretty sure reindexing a table takes out an exclusive lock, which
means you might wanna wait til off hours to do one.
On Tue, 2006-12-05 at 13:26, John Sidney-Woollett wrote:
To recover disk space, reindex the heavily updated tables. You can do
this while the database is in production.
On Tue, 2006-12-05 at 14:56, Wei Weng wrote:
I have a table that has roughly 200,000 entries and many columns.
The query is very simple:
SELECT Field1, Field2, Field3... FieldN FROM TargetTable;
TargetTable has an index that is Field1.
The thing is on this machine with 1Gig Ram, the
On Tue, 2006-12-05 at 14:56, Glen Parker wrote:
Scott Marlowe wrote:
On Mon, 2006-12-04 at 09:56, Schwenker, Stephen wrote:
I'm using version 7.4.2 on solaris.
A few points:
4: Look at migrating to 8.1 or even 8.2 (due out real soon now). There
have been a lot of advances in pg
On Tue, 2006-12-05 at 16:32, Tomi N/A wrote:
One type of query does come to mind, now that I think about it.
pgsql has trouble handling queries like
SELECT * FROM t0 WHERE t0.id_t1 IN (SELECT t1.id FROM t1 WHERE...)
When the subselect returns a lot of results, pgsql really takes it's time.
On Wed, 2006-12-06 at 10:15, Vivek Khera wrote:
On Dec 5, 2006, at 4:09 PM, Scott Marlowe wrote:
I recently tossed 8.1 on my workstation which runs a little reporting
application here. I pointed the app from 7.4 to 8.1 and got a visit
within about an hour from a user, asking if I'd done
On Wed, 2006-12-06 at 14:16, wheel wrote:
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
[ The author's email address is clearly bogus, so I can't privately send
him email.]
You seems to be trying to get help by supplying the least amount of
information possible, and not
On Wed, 2006-12-06 at 01:17, swati desai wrote:
i am trying to connect php to postgresql but im getting warning FATAL:
IDENT authentication failed... for user and pg_connect(dbname=swati
user=xyz password=abc);
and hence cant work
plz tell me wat is d problem
Your pg_hba.conf file isn't
On Wed, 2006-12-06 at 14:48, Curtis Braly wrote:
I recently installed this database to use with Sam Broadcaster for my
internet radio station. When I log into Sam Broadcaster is should
automatically connect to my database. It is giving me an error
message stating that it unable to connect to
On Thu, 2006-12-07 at 11:59, Tony Caduto wrote:
http://linux.inet.hr/poll_favorite_database.html
So far Firebird is in the lead :-(
Somebody just told their list earlier than anyone told us... or mysql's
list.
And Ingress has... 3 votes.
Man, that's gotta hurt.
Firebird is a great little
On Thu, 2006-12-07 at 12:05, Bricklen Anderson wrote:
Scott Marlowe wrote:
On Thu, 2006-12-07 at 11:59, Tony Caduto wrote:
http://linux.inet.hr/poll_favorite_database.html
So far Firebird is in the lead :-(
Somebody just told their list earlier than anyone told us... or mysql's
On Thu, 2006-12-07 at 13:04, Zoltan Boszormenyi wrote:
Scott Marlowe írta:
ouch! I stand corrected. Of course, I didn't register to vote either.
Are there more firebird users in hungary (.hr right?) than postgresql
maybe? I wonder.
Then stand a bit longer. :-)
Hungary is .hu
On Thu, 2006-12-07 at 02:41, wheel wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
On Wed, Dec 06, 2006 at 12:16:35PM -0800, wheel wrote:
re Bruce Momjian
Wow, what an unfriendly dude!
Well, he's one of the very guys who make all this
(PostgreSQL, that is) happen
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called gender which has one
On Fri, 2006-12-08 at 11:05, Joshua D. Drake wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
On Fri, 2006-12-08 at 09:16, Edoardo Panfili wrote:
I have a question regarding a strange behaviour (for me, maybe that this
is desidered feature) of LOCK on tables. I am using postgres 8.2
I have a servlet that uses connection pools.
The servlet do LOCK table,table2,table3,table4
then do
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
please, give me a
On Fri, 2006-12-08 at 15:44, Erik Jones wrote:
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product
On Fri, 2006-12-08 at 16:13, Jeff Davis wrote:
On Fri, 2006-12-08 at 22:04 +0100, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba
On Fri, 2006-12-08 at 16:08, Erik Jones wrote:
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:44, Erik Jones wrote:
Scott Marlowe wrote:
SNIP
Guess he's never heard of pgpool, slony, mammoth replicator, cjdbc, or a
half dozen other ways to get high reliability with postgresql
On Sat, 2006-12-09 at 13:19 +0500, Shoaib Mir wrote:
I guess TOAD uses OCI to interact with the database so there might be
problems connecting TOAD with PostgreSQL...
I've looked it up and can confirm what Tom said, TOAD works with
PostgreSQL, you just have to make sure you get the right
On Mon, 2006-12-11 at 10:06, Tom Lane wrote:
SunWuKung [EMAIL PROTECTED] writes:
It seems to me that if I dump and restore a database as a new db I need
to manually issue
ALTER DATABASE dbname SET search_path=schema1, schema2;
to get back the search_path of the original db.
ALTER
On Mon, 2006-12-11 at 10:12, Tony Caduto wrote:
Shoaib Mir wrote:
Thanks Scott, just confirmed it from TOAD's review at
http://www.pcsoftland.com/development-tools/databases/toad-for-sql-server.htm
Plus the SQL editor will actually function with any ODBC database
connection, thus it
On Mon, 2006-12-11 at 10:18, Jonathan Ellis wrote:
I have a table of log messages. They are mostly in the 100-200
character length, which apparently isn't large enough for PG to want
to compress it (length == octet_length). I really need to save disk
space. I can store it as a bytea and
On Wed, 2006-12-13 at 10:50, David Goodenough wrote:
http://developers.slashdot.org/article.pl?sid=06/12/13/1515217from=rss
MySQL quietly deprecated support for most Linux distributions on October 16,
when its 'MySQL Network' support plan was replaced by 'MySQL Enterprise.'
MySQL now
On Wed, 2006-12-13 at 12:01, Alvaro Herrera wrote:
Scott Marlowe wrote:
On Wed, 2006-12-13 at 10:50, David Goodenough wrote:
http://developers.slashdot.org/article.pl?sid=06/12/13/1515217from=rss
MySQL quietly deprecated support for most Linux distributions on October
16,
when
On Wed, 2006-12-13 at 15:36, Rafal Pietrak wrote:
On Wed, 2006-12-13 at 14:01 -0500, Tom Lane wrote:
Rafal Pietrak [EMAIL PROTECTED] writes:
I thought trigger functions execute at root/postgres security level?
No. You probably want to make that function SECURITY DEFINER so it
On Thu, 2006-12-14 at 11:28, dev wrote:
Hello friends,
we have some strange problem, postmaster (pg 8.1 /win32)
suddenly shutdown because of no reason.
The interesting thing is that this occurs always at
almost same time (between 0.00 and 0.30h), in that time period is
running system
On Tue, 2007-01-02 at 22:34 -0800, Mark Harrison wrote:
I have a cluster of CPUs generating thumbnails for
a render farm. I would like to place thumbnail
requests on a queue, and have the cluster of client
dequeue the requests and process them.
Of course, each request should be only
On Thu, 2007-01-04 at 11:11, Andy Dale wrote:
Hi,
I need to be able to determine the last time (and date) that a
database was written to. I know it could be possible just to check
the last modified dates in the PGDATA directory, but i need to compare
the last write time of 3 databases
On Fri, 2007-01-05 at 15:54, Jeremy Haile wrote:
Yeah - it can make it easier to implement transactional semantics by
storing them in the database, although for simple operations it wouldn't
be hard to replicate this manually. And you are going to incur a
performance penalty by storing them
On Fri, 2007-01-05 at 15:54, Raymond O'Donnell wrote:
Hi all,
Would there be any problem with using Slony-I to replicate from a
Windows server to Linux? Has anyone done this?
Also, is there a mailing list for Slony?
Should work. Try to have them run with the same locale setting (and
On Fri, 2007-01-05 at 16:19, Geoffrey wrote:
Geoffrey wrote:
We had a vacuum fail recently with the following error:
invalid page header in block 846 of relation move_pkey
Anyone have an idea what could cause this problem and what we need to do
to resolve it?
Running on Red
On Mon, 2007-01-08 at 02:22, Andy Dale wrote:
Hi,
Sorry for the slight delay in my response.
I am using 3 PostgreSQL databases and writing to them using an SQL
proxy. These databases have a high write volume. On rebooting all 3
servers for OS/Software updates, i would like to figure out
On Mon, 2007-01-08 at 03:26, Andy Dale wrote:
Ok.
The SQL Proxy i am using (HA-JDBC) has some limitations with regard to
getting it's cluster back into sync. If ha-jdbc uses the wrong DB
(one that has been out of action for a while) as the starting point
for the cluster it will then try
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command connect by prior and i need to use it in
PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I don't think there's anything like that in
On Mon, 2007-01-08 at 15:19, Curran Schiefelbein wrote:
If this is not the right list for this problem, could someone please
point me to the right area?
according to this page:
http://www.postgresql.org/community/lists/
Current win32 development issues should be raised on -hackers. Cygwin
On Mon, 2007-01-08 at 14:58, George Nychis wrote:
Hi,
I have approximately 2 billion data entries that I would like to insert into
a database.
Each entry consists of:
INT BOOLEAN INT BOOLEAN
I want to populate a table such that it only contains the unique rows, all
other data
should
On Mon, 2007-01-08 at 15:52, George Nychis wrote:
Scott Marlowe wrote:
On Mon, 2007-01-08 at 14:58, George Nychis wrote:
Hi,
I have approximately 2 billion data entries that I would like to insert
into a database.
Each entry consists of:
INT BOOLEAN INT BOOLEAN
I want
On Mon, 2007-01-08 at 15:59, George Nychis wrote:
Scott Marlowe wrote:
On Mon, 2007-01-08 at 15:52, George Nychis wrote:
Scott Marlowe wrote:
On Mon, 2007-01-08 at 14:58, George Nychis wrote:
Hi,
I have approximately 2 billion data entries that I would like to insert
On Tue, 2007-01-09 at 07:36, dcrespo wrote:
Hi everybody,
I have two computers with a Postgres Database each. I want one of them
to be the replica of the other one; let's say I want a Master to Master
replication in order to use either one (but only one at a time) as the
main database: in
On Tue, 2007-01-09 at 13:38, Jonathan Hedstrom wrote:
We recently upgraded from 8.1.4 to 8.2.0 on Fedora Core 6, and are now
seeing a few rather ominous-looking messages.
The problem started with this one, during an update involving a rather
complex view:
ERROR: invalid memory alloc
On Tue, 2007-01-09 at 17:17, Ben wrote:
And a related question: should a vacuum also clean out indexes on 7.3?
Should, might not. There definitely was a problem in 7.2 with indexes
on ever increasing values where the indexes would grow on one side of
the btree only. In 7.2 I had a table of
On Tue, 2007-01-09 at 23:12, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Tue, 2007-01-09 at 17:17, Ben wrote:
If I create an index on a table that needs to be vacuumed in 7.3, will the
dead rows get indexed as well?
Yes. I think. I'm pretty sure that's still true
On Wed, 2007-01-10 at 00:12, John DeSoi wrote:
On Jan 8, 2007, at 2:11 PM, Ron Mayer wrote:
If not postgres, what other database could possibly do this, if
any? I
really don't want to have to write our own RDBMS. :)
Doesn't seem much like a database question. I'd say ask on some
On Wed, 2007-01-10 at 12:37, Andy Dale wrote:
Hi Brad,
If i have to create a separate slony replication set, then i cannot do
it this way (i cannot and do not want to have a master-slave(s)
architecture)
Andy
On 10/01/07, Brad Nicholson [EMAIL PROTECTED] wrote:
On Wed,
On Tue, 2007-01-09 at 19:54, [EMAIL PROTECTED] wrote:
Hello,
I am working on a project where we are converting from MySQL to
Postgres. I figured the easiest way would be to export the MySQL data
as CSV.
I'm having a problem importing some of the data. What I have done is
exported the
On Wed, 2007-01-10 at 16:51, [EMAIL PROTECTED] wrote:
The missing quote after Poster is a mistake I made when sanitzing the
data for posting here. That error is NOT present in the actual data.
There is a quote where needed in the data. So, with that in mind, why
am I still getting the error?
On Fri, 2007-01-12 at 10:50, Stéphane Schildknecht wrote:
Dear community members,
I'm having a quite strange behaviour while trying to drop some index.
We have some tables with two indexes on a primary key. The first one was
automatically created by the primary constraint. The second one
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
Sent: Friday, January 12, 2007 12:59 PM
To: Stéphane Schildknecht
Cc: pgsql general
Subject: Re: [GENERAL] FK Constraint on index not PK
On Fri, 2007-01-12 at 10:50, Stéphane Schildknecht wrote:
Dear community members
On Mon, 2007-01-15 at 23:26, Tom Lane wrote:
carter ck [EMAIL PROTECTED] writes:
And you are definitely right when updating the table. The time it takes is
getting longer and longer. When I do a select statement, the speed has also
degraded.
Seems like you need a VACUUM in there
On Thu, 2007-01-18 at 02:03, Thuy Nguyen wrote:
Hi Sir/Madam!
I am look for RDBMS solution for my web application, size of my
database may be about 10GB--500GB. How PostgreSQL work well or how
must I config it?
My application process data locally; one database has only one
connection (not a
On Sun, 2007-01-21 at 10:01, Shashank wrote:
It seems MySQL just dropped the ball on
the free version of their product, and it
Not sure what you mean. I can download their latest versions without
any trouble.
Additionally, they feel that Oracle is such a threat that they have dumped
On Fri, 2007-01-26 at 15:06, Bill Moran wrote:
In response to BluDes [EMAIL PROTECTED]:
Any suggestion?
In any event, refuse to ever do any business with him again. In my
experience, these kinds of customers aren't worth the pennies they pay
you. Also, refuse to give in. If you
On Tue, 2007-01-30 at 23:45 -0600, Tony Caduto wrote:
David Fetter wrote:
That being said, I think it is a dumb feature. If you have data in
one database, that requires access to another database within the
same cluster. You designed your database incorrectly and should be
using schemas.
On Thu, 2007-02-01 at 15:15, Richard Troy wrote:
Hello All,
it was recently brought to my attention that last year the U.S. altered
the dates when Daylight Savings Time starts and ends. Many if not most
computers presume the old change dates and therefore, if left to change
automatically,
On Thu, 2007-02-01 at 16:40, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 15:15, Richard Troy wrote:
Hello All,
it was recently brought to my attention that last year the U.S. altered
the dates when Daylight Savings Time starts and ends. Many if not
On 7/7/07, rupesh bajaj [EMAIL PROTECTED] wrote:
Hi,
When I run the following query Postmaster crashes. For your reference I have
attached information regarding the query (query plan, table , index, server
log).
My observation is that when Postmaster starts taking lot of memory because
of which
On 7/18/07, Benjamin Arai [EMAIL PROTECTED] wrote:
Hi,
If I have a query such as:
SELECT * FROM (SELECT * FROM A) UNION ALL (SELECT * FROM B) WHERE
blah='food';
Assuming the table A and B both have the same attributes and the data
between the table is not partitioned in any special way, does
On 7/20/07, Bill Moran [EMAIL PROTECTED] wrote:
In response to Tom Lane [EMAIL PROTECTED]:
Bill Moran [EMAIL PROTECTED] writes:
I'm now full of mystery and wonder. It would appear as if the
underlying problem has something to do with PHP, but why should this
cause a backend process to
On 7/23/07, Chuck Payne [EMAIL PROTECTED] wrote:
Hey,
I have spend the last several days looking for a website or how to that
would show me how to call postgresql in bash script. I know that in mysql I
can do like this
for i in `cat myfile.txt` ; do mysql -uxxx -p -Asse mydatabase insert
On 8/1/07, Madison Kelly [EMAIL PROTECTED] wrote:
Joseph S wrote:
I just moved one of my desktops and my laptop from Fedora 6 to Unbuntu
7.04 because Fedora lacked hardware support that Unbuntu and my Fedora
machines had all sorts of problems like sound dropping out and machines
locking
On 8/1/07, Mason Hale [EMAIL PROTECTED] wrote:
On a 8.1.9 version database that has been recently vacuumed and
analyzed, I'm seeing some dramatic performance degradation if a limit
clause is included in the query. This seems counter-intuitive to me.
Here's the query and explain plan WITH the
On 8/2/07, Andrej Ricnik-Bay [EMAIL PROTECTED] wrote:
On 8/2/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND
4735 root 18 0 52524 7204 4304 S 0.0 0.4 0:00.01 httpd
4820 root 15 0 141m 6648 3140 S 0.0
I'd like to know what the age of the oldest running transaction is.
i.e. hunt look out for old idle in transaction transactions that are
holding up vacuuming.
Info on the shared buffers like % used, % that hasn't been updated or
seen in x minutes / hours / days.
% used on various tablespaces
On 8/7/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello all
I use a crontab job to backup and restore my database every midnight every
day (using pg_dump and restore...)
Backup from one machine, restore to another, right?
My cron job run well for a while. However, today I discovered
On 8/5/07, Sergei Shelukhin [EMAIL PROTECTED] wrote:
Hi.
Is there any way to truncate WAL log in postgres?
We want to use full-backup strategy where we stop the server and copy
the data directory, however WAL log is taking dozens gigabytes of
spaces.
Is there any way to remove it while
On 8/7/07, Owen Hartnett [EMAIL PROTECTED] wrote:
Here's what I want to do:
Checkpoint the database in whatever way is appropriate.
Make copies of the database on several laptops for use in the field
(in automobiles) to do database changes. Record all the changes made
since the checkpoint
On 8/7/07, Owen Hartnett [EMAIL PROTECTED] wrote:
At 2:15 PM -0700 8/7/07, Ben wrote:
How many users do you have? Have you considered giving each user a
schema in which to make their changes? It sounds like you don't
really have a multi-master replication issue, which makes things
easier.
1 - 100 of 3611 matches
Mail list logo