Hi Tom,
On Mar 25, 2009, at 9:02 PM, Tom Lane wrote:
Tom Duffey 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 mill
> >> >> > 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 b
On Wed, Mar 25, 2009 at 8:23 PM, Tatsuo Ishii 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 6
> >> > 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
>
>
>
> slony?
>
That sound more like a question than an answer :)
Can I presume it doesn't care about the architecture of the OS?
On Wed, Mar 25, 2009 at 7:08 PM, Tim Uckun wrote:
>
> On Thu, Mar 26, 2009 at 2:05 PM, Tatsuo Ishii 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
Tom Duffey 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 the constraint failed
On Thu, Mar 26, 2009 at 2:05 PM, Tatsuo Ishii 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
32 bit machin
> 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:
http://www.
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.
Hola
use Ñ 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
rec
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 goal.player_id
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 http://www.mysqlconf.
On Thu, Mar 26, 2009 at 2:23 AM, Bill Moran wrote:
> In response to Tim Uckun :
>
> > 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
On Wed, Mar 25, 2009 at 2:24 PM, aravind chandu 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, or multiple queries
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 characte
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
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.
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
Magnus Hagander 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 yes, it's b
William Harrower 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" for shared librar
Increase effective_cache_size parameter.
An "effective_cache_size=11GB" should be more than enough.
-Original Message-
From: DM
To: pgsql-ad...@postgresql.org, pgsql-general@postgresql.org,
pgsql-...@postgresql.org
Subject: [ADMIN] Can we load all database objects in memory?
Date: Wed,
On Wed, Mar 25, 2009 at 7:04 PM, Richard Broersma
wrote:
> On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander 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
>>
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?
On Wed, Mar 25, 2009 at 1:20 PM, DM 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 they'll be in
ke
On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander 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?
Thanks gu
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 5:59 PM, Joshua D. Drake 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 originally release
On Wed, Mar 25, 2009 at 11:42 AM, Phoenix Kiula 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 of this is VIEW cont
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
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 followi
On Wed, Mar 25, 2009 at 12:50:01PM -0400, Merlin Moncure wrote:
> 2009/3/25 Grzegorz Jaśkiewicz :
> > 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 in my opi
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 messag
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 utilit
2009/3/25 Merlin Moncure :
> 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 subscription:
http://www.post
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
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'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 --trace-children=y
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 directo
2009/3/25 Grzegorz Jaśkiewicz :
> 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:
http://www.postgresql.
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
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:3
Mike Charnoky wrote:
Scott Marlowe wrote:
On Mon, Mar 9, 2009 at 8:21 PM, Mike Charnoky 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 consistently quick, too.
On Mon, Mar 23, 2009 at 2:13 PM, Peter Willis 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
>
> INSERT INT
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 , non-ge
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
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
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
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, ple
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
In response to Tim Uckun :
> 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
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
-Ursprüngl
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 o
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: pgsql-general-ow...@postgres
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: pgsql-general@p
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:
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 follo
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 system.
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 repor
59 matches
Mail list logo
