Erik Jones wrote:
These are all client databases at the web hosting company I work at.
I can't go putting triggers on all of their tables. I think I'll
just
start taking snapshots of pertinent data from pg_stat_activity and
after I've been collecting data for a while run a
Today the database shut down unexpectedly. I have included the log file
that shows the shutdown. Can anybody tell me why this happened and how I can
make sure it doesn't happen again.
The only thing I can think of that I did was to specify a password for the
postgres user in the operating
Hi,
Martijn van Oosterhout wrote:
And fsync better do what you're asking
(how fast is just a performance issue, just as long as it's done).
Where are we on this issue? I've read all of this thread and the one on
the lvm-linux mailing list as well, but still don't feel confident.
In the
Hello everybody. In the last week i'm having a trouble with my
PostgreSQL working on Windows XP Professional.
When i boot, Postgresql works correctcly, but after about an hour it
stops working, an i get timeouts when i try to connect to it.
In the postgresql log, i get this message:
you have a power saving mode enabled? of inactivity when your pc shuts down
etc?
King Regards
-Ursprüngliche Nachricht-
Von: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von Tk421
Gesendet: Mittwoch, 25. März 2009 11:32
An:
Power saving mode is disabled, and i get the error even until i'm
working.
Best regards
Benedikt Schackenberg escribió:
you have a power saving mode enabled? of inactivity when your pc shuts down
etc?
King Regards
-Ursprüngliche Nachricht-
Von:
In my ethernet connection I've got only one IP address, and i've
tried with Static IP and with DHCP, and the error Stills.
Ii've got two aditional network adapters active (created by vmware
for virtualizations). May this be the cause of the error? I will try to
set postgres to listen only
I've configured postgreSQL server to listen only in one IP address
and the error stills.
Anyone has more ideas to solve it?
Best regards
Benedikt Schackenberg escribió:
you have a power saving mode enabled? of inactivity when your pc shuts down
etc?
King Regards
In response to Tim Uckun timuc...@gmail.com:
Today the database shut down unexpectedly. I have included the log file
that shows the shutdown. Can anybody tell me why this happened and how I can
make sure it doesn't happen again.
The only thing I can think of that I did was to specify a
On Wednesday 25 March 2009 5:58:33 am Tk421 wrote:
I've configured postgreSQL server to listen only in one IP address
and the error stills.
Anyone has more ideas to solve it?
In the past week have you installed any other software or changed the behavior
of software? In particular I
Hello. Since release 8.2 row comparisons work well - thanks! It would be nice
if MIN and MAX aggregate functions could operate on row values, so I could
write in SQL:
SELECT MIN(ROW(a, b, c, d)) FROM table
to find extreme value of ordered set of columns. It should not be hard to
implement,
On 25/03/2009 02:21, berdam wrote:
how to unsubscribe of this list??
Instructions are at the bottom of every post sent out via this mailing
list.
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
Daniel Verite wrote:
Note that htmlentities() expects LATIN1-encoded strings and is thus
unusable on UTF-8 contents.
So if you end up talking UTF-8 with the database, you'll probably need
to use htmlspecialchars() instead, and UTF-8 as your HTML charset.
I believe you are wrong, at least the
least()
greatest().
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Brent,
I am aware of PostGIS and already use it. My question was regarding
the entry format of PostgreSQL polygon data. There is a void
in the PostgreSQL documentation regarding this.
Incidentally, PostGIS uses PostgreSQL polygon, point, and path
data types.
Using PostGIS for simple ,
On Mon, Mar 23, 2009 at 2:13 PM, Peter Willis pet...@borstad.com wrote:
For example:
I have a triangle with vertex corners A, B, C.
One entry per vertex format suggests
INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Cx,Cy)) );
One entry per edge format suggests
Mike Charnoky wrote:
Scott Marlowe wrote:
On Mon, Mar 9, 2009 at 8:21 PM, Mike Charnoky n...@nextbus.com wrote:
The random sampling query is normally pretty snappy. It usually takes on
the order of 1 second to sample a few thousand rows of data out of a few
million. The sampling is
No, the last week i didn't installed any software. The only
possible installation may be a instalation of some windows update. I
will look for it, and if there is some thing about any
antivirus/firewall update.
Best regards.
Adrian Klaver escribi:
On Wednesday 25 March 2009 5:58:33 am
Hi,
Does anyone know if there are plans to make deferrable contraints not just
limited to foreign keys? Like unique or check contraints? It would have
been very useful today, but obviously we're having to come up with a less
elegant solution.
Thanks
Thom
2009/3/25 Grzegorz Jaśkiewicz gryz...@gmail.com:
least()
greatest().
Actually, these answer a different question, OP is interested in using
aggregate on composite type...
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Using the following links to get to the PostgreSQL 8.3.7 (Windows)
one-click installer:
http://www.postgresql.org/download/windows
http://www.enterprisedb.com/products/pgdownload.do#windows
and then running the update utility, I get the following error message:
[Error]
The existing data
Hi,
I'm attempting to profile (the memory usage and CPU time of) some code
I've written as part of a custom datatype. I've attempted to utilise
valgrind and cachegrind, but this doesn't seem to work as expected. The
following is the command used:
valgrind --tool=cachegrind
Mark Cave-Ayland wrote:
Peter Willis wrote:
Incidentally, PostGIS uses PostgreSQL polygon, point, and path
data types.
Errr... no it doesn't. PostGIS uses its own internal types to represent
all the different geometries, although it does provide a cast between
the existing PostgreSQL types
Hi. I have a questionf or people who run high traffic websites.
We are considering a new dedicated server host for a set of 25
domains, about 5 of which are very high traffic (80 million clicks a
day each). A lot of this is VIEW content, but there may be a million
or so INSERTs and UPDATEs.
I am
2009/3/25 Merlin Moncure mmonc...@gmail.com:
Actually, these answer a different question, OP is interested in using
aggregate on composite type...
true, I was too quick ... :)
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Wed, 2009-03-25 at 10:25 -0700, Richard Broersma wrote:
Using the following links to get to the PostgreSQL 8.3.7 (Windows)
one-click installer:
http://www.postgresql.org/download/windows
http://www.enterprisedb.com/products/pgdownload.do#windows
and then running the update utility, I
Richard Broersma wrote:
Using the following links to get to the PostgreSQL 8.3.7 (Windows)
one-click installer:
http://www.postgresql.org/download/windows
http://www.enterprisedb.com/products/pgdownload.do#windows
and then running the update utility, I get the following error message:
On Wed, Mar 25, 2009 at 12:50:01PM -0400, Merlin Moncure wrote:
2009/3/25 Grzegorz Jaśkiewicz gryz...@gmail.com:
least()
greatest().
Actually, these answer a different question, OP is interested in using
aggregate on composite type...
I think Grzegorz was pointing out (rather too tersely
Hi All,
One of our databases suffered a problem yesterday during a normal
update, something we have been doing for years. Near the end of the
process a foreign key constraint is rebuilt on a table containing
several hundred million rows. Rebuilding the constraint failed with
the
Hi All,
I have a database of 10GB.
My Database Server has a RAM of 16GB
Is there a way that I can load all the database objects to memory?
Thanks for your time and taking a look at this question.
Thanks
Deepak
On Wed, Mar 25, 2009 at 11:42 AM, Phoenix Kiula phoenix.ki...@gmail.com wrote:
Hi. I have a questionf or people who run high traffic websites.
We are considering a new dedicated server host for a set of 25
domains, about 5 of which are very high traffic (80 million clicks a
day each). A lot
On Wed, Mar 25, 2009 at 5:59 PM, Joshua D. Drake j...@commandprompt.com wrote:
Q2) Is integer timestamps becoming the new default from the previous
floating point data type?
In 8.4 yes. Not sure why the windows installer does that now.
An error on my part - the one-click installer was
Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory
On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander mag...@hagander.net wrote:
Q2) Is integer timestamps becoming the new default from the previous
floating point data type?
My guess is that your previous install was from the community MSI
installer, and not the one-click one. Could that be
On Wed, Mar 25, 2009 at 1:20 PM, DM dm.a...@gmail.com wrote:
Hi All,
I have a database of 10GB.
My Database Server has a RAM of 16GB
Is there a way that I can load all the database objects to memory?
Just replying to pgsql-general...
Yeah, just select * from table for each table, then
On Wed, 2009-03-25 at 23:12 +0530, Phoenix Kiula wrote:
Hi. I have a questionf or people who run high traffic websites.
My question: What's the high end recommendation? Is the following
config of 4 x quadcore Dunnington Intels with 4 disks on RAID 10 be
good enough for the above sites? Can
On Wed, Mar 25, 2009 at 7:04 PM, Richard Broersma
richard.broer...@gmail.com wrote:
On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander mag...@hagander.net wrote:
Q2) Is integer timestamps becoming the new default from the previous
floating point data type?
My guess is that your previous
Increase effective_cache_size parameter.
An effective_cache_size=11GB should be more than enough.
-Original Message-
From: DM dm.a...@gmail.com
To: pgsql-ad...@postgresql.org, pgsql-general@postgresql.org,
pgsql-...@postgresql.org
Subject: [ADMIN] Can we load all database objects in
William Harrower wjh...@doc.ic.ac.uk writes:
Ignoring valgrind specifically, does anyone know of any other tools that
can be used to profile the memory usage and CPU time/load of a custom
datatype library?
oprofile on recent Fedora (and probably other Linux distros) pretty much
just works
Magnus Hagander mag...@hagander.net writes:
Richard Broersma wrote:
Q2) Is integer timestamps becoming the new default from the previous
floating point data type?
My guess is that your previous install was from the community MSI
installer, and not the one-click one. Could that be it?
(and
Stephen Cook wrote:
Daniel Verite wrote:
Note that htmlentities() expects LATIN1-encoded strings and is thus
unusable on UTF-8 contents.
So if you end up talking UTF-8 with the database, you'll probably
need
to use htmlspecialchars() instead, and UTF-8 as your HTML charset.
Hello,
I have a few questions related to the parallel query processing.Can
you guys tell me how to implement parallel query processing in postgresql
database.
Thanks,
Avin.
Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory
Hi, I'm experiencing a weird behavior when storing latin characters to a
PostgreSQL 8.3.1.876 server. The database is Latin1 encoded, and it is
working since September 2008, it wasn't updated nor replaced since its
first installation.
The weirdness of the problem is that sometimes the
On Wed, Mar 25, 2009 at 2:24 PM, aravind chandu avin_frie...@yahoo.com wrote:
Hello,
I have a few questions related to the parallel query
processing.Can you guys tell me how to implement parallel query processing
in postgresql database.
Do you mean one query being parallelized,
On Thu, Mar 26, 2009 at 2:23 AM, Bill Moran wmo...@potentialtech.comwrote:
In response to Tim Uckun timuc...@gmail.com:
Today the database shut down unexpectedly. I have included the log file
that shows the shutdown. Can anybody tell me why this happened and how I
can
make sure it
For those who are interested in performance overall and want a good
free technical conference, we're holding our first Performance
Conference. Bullet points:
* April 22 and 23, Santa Clara Convention Center, Santa Clara, California USA
* Same time place as MySQL Conference
Hi there, I was trying this query:
SELECT player.name, pos.position, count(event.event_id) AS APP,
count(goal.event_id) AS GOAL
FROM t_events event, t_events goal, t_players player, t_positions pos
WHERE player.position_id=pos.id
AND player.team_id=2
AND event.player_id=player.id
AND
Hola
use #209; for spanish N
http://webdesign.about.com/od/localization/l/blhtmlcodes-sp.htm
Saludos Cordiales desde EEUU!
Martin
__
Disclaimer and confidentiality note
This message is confidential and may be privileged. If you are not the intended
According to the documentation it's not possible to log ship from a 64 bit
server to a 32 bit server.
I just want to confirm that this is the case before I waste a whole lot of
time trying to set it up.
According to the documentation it's not possible to log ship from a 64 bit
server to a 32 bit server.
I think the doc is quite correct.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Thu, Mar 26, 2009 at 2:05 PM, Tatsuo Ishii is...@postgresql.org wrote:
According to the documentation it's not possible to log ship from a 64
bit
server to a 32 bit server.
I think the doc is quite correct.
So what is the best way to accomplish a failover from a 64 bit machine to a
Tom Duffey tduf...@techbydesign.com writes:
One of our databases suffered a problem yesterday during a normal
update, something we have been doing for years. Near the end of the
process a foreign key constraint is rebuilt on a table containing
several hundred million rows. Rebuilding
On Wed, Mar 25, 2009 at 7:08 PM, Tim Uckun timuc...@gmail.com wrote:
On Thu, Mar 26, 2009 at 2:05 PM, Tatsuo Ishii is...@postgresql.org wrote:
According to the documentation it's not possible to log ship from a 64
bit
server to a 32 bit server.
I think the doc is quite correct.
So
slony?
That sound more like a question than an answer :)
Can I presume it doesn't care about the architecture of the OS?
According to the documentation it's not possible to log ship from a 64
bit
server to a 32 bit server.
I think the doc is quite correct.
So what is the best way to accomplish a failover from a 64 bit machine to a
32 bit machine?
slony?
IMO Slony doesn't do failover.
--
On Wed, Mar 25, 2009 at 8:23 PM, Tatsuo Ishii is...@postgresql.org wrote:
According to the documentation it's not possible to log ship from a 64
bit
server to a 32 bit server.
I think the doc is quite correct.
So what is the best way to accomplish a failover from a 64 bit
According to the documentation it's not possible to log ship from a 64
bit
server to a 32 bit server.
I think the doc is quite correct.
So what is the best way to accomplish a failover from a 64 bit machine
to a
32 bit machine?
slony?
IMO Slony doesn't do
Hi Tom,
On Mar 25, 2009, at 9:02 PM, Tom Lane wrote:
Tom Duffey tduf...@techbydesign.com writes:
One of our databases suffered a problem yesterday during a normal
update, something we have been doing for years. Near the end of the
process a foreign key constraint is rebuilt on a table
59 matches
Mail list logo
