Justin,
It is an image viewing system for events. Each event could have a few
hundred images (each one will be between a 3 to 12 megs file) and as many as
one hundred thousand images. So these are the other files, the other
folders is how all these images are stored and managed. The database
co
On Tue, Mar 9, 2010 at 11:49 PM, Phillip Berry
wrote:
> Hi Everyone,
>
> We're in the market for a new DB server to replace our current one (yes it's
> one of *those*
> questions) ;).
>
> It'll have quad core Xeons, 36GB RAM and some sort of Raid 10 configuration.
>
> Our provider is pushing us t
On ons, 2010-03-10 at 12:04 +0600, AI Rumman wrote:
> I am getting the following error during Postgresql 8.1 installation:
>
> error: C preprocessor "/lib/cpp" fails sanity check
>
> Please any suggestion how to solve it.
Check the config.log file. I would guess it's somewhat likely that you
Hi Everyone,
We're in the market for a new DB server to replace our current one (yes it's
one of *those*
questions) ;).
It'll have quad core Xeons, 36GB RAM and some sort of Raid 10 configuration.
Our provider is pushing us towards 6 x SATA II disks in a Raid 10 configuration
or 4 x SAS disks
AI Rumman wrote:
I am getting the following error during Postgresql 8.1 installation:
error: C preprocessor "/lib/cpp" fails sanity check
Please any suggestion how to solve it.
what platform (os, version, etc) are you building postgres on?
what C++ compiler is that? thats an unusual path
I am getting the following error during Postgresql 8.1 installation:
error: C preprocessor "/lib/cpp" fails sanity check
Please any suggestion how to solve it.
All links to download postgres are carefully hidden under
http://www.postgresql.org/download/
Whether or not there is a link there to the particular platform and package
format you want depends upon which one you're looking for. But a few minutes of
looking should let you determine the answer t
Please tell me the link to download Postgresql 8.1
Greg Sabino Mullane wrote:
> Bruce replied:
> ...
> >> This means that, even using syslog as a destination, it's not possible for
> >> me to filter statements without some sort of log-text parsing, which I'd
> >> prefer to avoid on effort, performance and data-integrity grounds.
>
> > Our logging
--
===
Andrew Boag
Director
Catalyst IT Australia
Suite 401, 89 York St
Sydney 2000
http://www.catalyst-au.net
andrew.b...@catalyst-au.net
+61 421 528 125
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Andre Lopes escribió:
> It is possible to do this in a shared database server?
You can also do
ALTER DATABASE foo SET timezone TO 'someval'
ALTER ROLE bar SET timezone TO 'someval'
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Pr
zhong ming wu wrote:
Is it possible to have a warm standby with 8.1?
No. You can set that up so that it replays an entire pile of log files
sitting there when you start the server, which it sounds like you
haven't managed yet because you're trying to treat it like a
warm-standby. But 8.1 i
Andre Lopes wrote:
It is possible to do this in a shared database server?
sure, client timezone is a per connection setting.
SET TIME ZONE 'WET';
or
SET TIME ZONE 'Europe/Lisbon';
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
It is possible to do this in a shared database server?
Best Regards,
On Tue, Mar 9, 2010 at 9:54 PM, Tom Lane wrote:
> Andre Lopes writes:
> > I have a database in a US based Server. I need to get a TIMESTAMP with
> the
> > PORTUGAL time. How can I do this?
>
> Try AT TIME ZONE, or just temp
Andre Lopes writes:
> I have a database in a US based Server. I need to get a TIMESTAMP with the
> PORTUGAL time. How can I do this?
Try AT TIME ZONE, or just temporarily change the timezone setting.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-genera
On Tue, 2010-03-09 at 16:27 -0500, akp geek wrote:
> we have are using postgis. I am running into this
> scenarios. When the query is executed it is displaying information as
> " 780/24 520 (500- ? ) " as opposed to " 780/24 520 (500- 1/4 )" .
> It's doing in many part. Has any one r
Lookup "bonjour" support in postgres server docs.
On Tue, Mar 9, 2010 at 4:17 PM, imageguy wrote:
> Is there a recommended way of "discovery" a PG server on the network ?
>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
Hi all -
we have are using postgis. I am running into this scenarios.
When the query is executed it is displaying information as " 780/24 520
(500- ? ) " as opposed to " 780/24 520 (500- 1/4 )" . It's doing in many
part. Has any one run into this kind of issue? Is it related to the
Howdy;
We have written an application that uses PG as the backend database.
We currently embed the database servers IP address in a text file that
the installed (created using Inno) uses when setting up the client
programs (ie, stores this info in a local .ini file).
Is there a recommended way of
On Tue, Mar 09, 2010 at 11:58:58AM -0500, Greg Smith wrote:
> Rodger Donaldson wrote:
> >Cyril Scetbon wrote:
> >>Does anyone know what can be the differences between linux kernels
> >>2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !)
> >>http://www.phoronix.com/scan.php?page=article
Hi,
I have a database in a US based Server. I need to get a TIMESTAMP with the
PORTUGAL time. How can I do this?
Best Regards,
Hi John,
pgsql-general@postgresql.org is perhaps a better idea
to post this. You've posted the message to the regional
Russian mailing list where the audience is somewhat of
a narrower scope.
-s
On Tue, Mar 9, 2010 at 10:19 AM, John KEA wrote:
> style="font: inherit;">Dear PostgreSQL Creators,
On Mar 8, 2010, at 7:16 AM, Tom Lane wrote:
> After it's done you probably ought to look into your autovacuum
> settings. You shouldn't have gotten into a state with so many dead
> tuples in the first place, I would think, if autovac were functioning
> properly.
Yeah, it turns out our autovacuum
Thomas Kellerer wrote:
> Hi,
>
> I just noticed that that there are functions defined (such as
> pg_catalog.time(timestamp) that can only be called when prefixed with
> pg_catalog. However other functions (that are at first glance defined
> identically to time()) can be called without prefixing
On 03/09/2010 10:09 AM, Thomas Kellerer wrote:
Raymond O'Donnell wrote on 09.03.2010 18:39:
This is Postgres you're talking about - of course it's that easy! :-)
:)
The main reason I asked, was that the manual actually claims that '\t'
can be used ("The following special backslash sequences a
On Mar 9, 2010, at 11:00 AM, Tom Lane wrote:
Dan Fitzpatrick writes:
The rule is creating a new value from the sequence a_a_id_seq for
"new.options_id" on each UPDATE call. How do I use the variable
new.options_id in the three update statements without incrementing
the
sequence again?
You
Thomas Kellerer writes:
> The main reason I asked, was that the manual actually claims that '\t' can be
> used ("The following special backslash sequences are recognized by COPY FROM")
\t is recognized in the copy data, not in the command's parameters.
regards, tom lane
March 9th, 2010
PostgreSQL Conference East, the largest PostgreSQL Conference for Users,
Developers, Decision makers and anyone using PostgreSQL arranged for a
hotel discount for attendees from the Radisson Warwick Hotel (the
location of the conference).
The retail price of a double room is ~ 199
On 3/9/2010 12:07 AM, Sam Carleton wrote:
> I would like to thank both John and Scott for the help. It is very
> clear to me that PostgreSQL isn't the ideal solution for my current
> model. The conversation has gotten me thinking of ways the model
> could be modified to work with PostgrSQL (an
On Tue, Mar 9, 2010 at 9:56 AM, Scott Marlowe wrote:
> On Tue, Mar 9, 2010 at 6:47 AM, Scot Kreienkamp
> wrote:
> > Wish I could Tom. I need a non-production, read-write copy of the
> > database that is updated every 1-2 hours from production. I don't set
> > this requirement, the business does.
ISTM that 9.0's read-only standby feature may be of use to you. I know
it doesn't help you *today* but have you looked at it yet?
[Scot Kreienkamp]
I had considered it and it will make my life easier for my reporting
server, but unfortunately in this case I need a read-write copy.
Raymond O'Donnell wrote on 09.03.2010 18:39:
This is Postgres you're talking about - of course it's that easy! :-)
:)
The main reason I asked, was that the manual actually claims that '\t' can be used
("The following special backslash sequences are recognized by COPY FROM")
As this is part o
On Tue, Mar 9, 2010 at 6:47 AM, Scot Kreienkamp wrote:
> Wish I could Tom. I need a non-production, read-write copy of the
> database that is updated every 1-2 hours from production. I don't set
> this requirement, the business does. I just have to do it if it's
> technically possible.
>
> I foun
Dan Fitzpatrick writes:
> The rule is creating a new value from the sequence a_a_id_seq for
> "new.options_id" on each UPDATE call. How do I use the variable
> new.options_id in the three update statements without incrementing the
> sequence again?
You don't. This is one of the major disad
Would the stats come across in WAL log shipping to a physically separate
server? My understanding is that they won't.
Thanks,
Scot Kreienkamp
skre...@la-z-boy.com
-Original Message-
From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark
Sent: Tuesday, March 09, 201
Tom Lane writes:
> Steve Coleman writes:
>> My problem is that 8.4.2 source has no "Makefile.global". This file is
>> essential I believe, and is used by all of the Makefiles in the source
>> tarball.
> Makefile.global is created by the configure step. This has not changed
> since 8.1.
On s
On 09/03/2010 13:51, venkatra...@tcs.com wrote:
> Hello,
>
> In postgre, when i am trying to give alias name in update statement like
> below -
>
> -
> update mytable x
> set x.name = 'asdf'
> where x.no = 1
> ---
Leave leave off the
I think I found the problem with this. The rule:
CREATE OR REPLACE RULE insert_options AS
ON INSERT TO options DO INSTEAD
(INSERT INTO a (a_id, type_id, name)
VALUES (new.options_id, 6, new.options_name);
UPDATE a_item SET val = new.quantity
WHERE a_item.a_id = new.options_id
On Tue, Mar 9, 2010 at 10:28 AM, Jignesh Shah
wrote:
> Could you tell me is there any other robust way to make sure that user1
> doesn't have CREATE permissions on mydb schema?
It depends what you're worried about. If you're worried that plperl
will begin mapping booleans to perl variables differ
On 09/03/2010 17:30, Thomas Kellerer wrote:
> Tom Lane wrote on 09.03.2010 18:21:
>> Thomas Kellerer writes:
>>> \copy foo (foo, bar) from foobar.txt delimiter as '\t' csv header
>>
>>> So how can I specify a tab character if I also need to specify that
>>> my file has a header line?
>>
>> Type an
On Tuesday 09 March 2010 5:51:31 am venkatra...@tcs.com wrote:
> Hello,
>
> In postgre, when i am trying to give alias name in update statement like
> below -
>
> -
> update mytable x
> set x.name = 'asdf'
> where x.no = 1
> ---
>
> is giv
Steve Coleman writes:
> My problem is that 8.4.2 source has no "Makefile.global". This file is
> essential I believe, and is used by all of the Makefiles in the source
> tarball.
Makefile.global is created by the configure step. This has not changed
since 8.1. If you want to create a file th
Tom Lane wrote on 09.03.2010 18:21:
Thomas Kellerer writes:
\copy foo (foo, bar) from foobar.txt delimiter as '\t' csv header
So how can I specify a tab character if I also need to specify that my file has
a header line?
Type an actual tab.
Blush
That easy?
Thanks
Thomas
--
Se
Harald Fuchs writes:
> Martijn van Oosterhout writes:
>> What you're missing is that in postgres NULLs are stored as a bit in
>> the header and there is no data. So in a sense NULLs take no space
>> (well, one bit) which means both statements are true.
> But if you already have eight nullable co
Hi,
I am moving from version 8.1.4 to 8.4.2 and have set up a Ubuntu box configured
with the 8.4.2 postgres one-click installer. It works great!
I imported everything from 8.1.4 with only two failures, and those were
homegrown "C" encryption / decryption functions that we use here.
For 8.1.4
Thanks for the suggestion. I wasn't able to get the whole pg to compile -
but I was able to take one of the contrib packages and use that as a
template for my needs.
Bryan.
On Wed, Feb 24, 2010 at 2:00 AM, Magnus Hagander wrote:
> 2010/2/23 Bryan Montgomery :
> > Hello,
> > I have a very simple
Thomas Kellerer writes:
> \copy foo (foo, bar) from foobar.txt delimiter as '\t' csv header
> So how can I specify a tab character if I also need to specify that my file
> has a header line?
Type an actual tab.
regards, tom lane
--
Sent via pgsql-general mailing list
In article <20100308213549.gb...@svana.org>,
Martijn van Oosterhout writes:
>> "subsequent ... will store a null value" would imply that deleted columns
>> will still take some place, while "the space will be reclaimed ..." would
>> suggest that new rows (insert or updates in mvcc) don't have t
Hi,
I tried to import a text file using the \copy command in psql using the
following:
\copy foo (foo, bar) from foobar.txt delimiter as '\t' csv header
but that gives me an error:
ERROR: COPY delimiter must be a single one-byte character
So how can I specify a tab character if I also need
Rodger Donaldson wrote:
Cyril Scetbon wrote:
Does anyone know what can be the differences between linux kernels
2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !)
http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2
http://www.csamuel.org/2009/04/11/default-ex
I have a table with a trigger that inserts records into a second table
on insert. I have a view that has a rule that inserts a record into
the first table then updates the records that the first table's
trigger inserted into the second table. From what I can see, when the
view rule executes
Steve Atkins writes:
> Postgresql is supposed to cope with file descriptor limits quite happily, as
> long as the OS actually restricts the number of files a process can have
> open. If it doesn't restrict the number, just falls over if there's too many,
> there's a postgresql configuration opt
I would just like to thank Albe and Jasen for their responses. What an
extraordinary environment Postgres is! Human and computing.
On Tue, Mar 9, 2010 at 1:32 PM, Albe Laurenz wrote:
> John Gage wrote:
> > I would like to use the following query:
> >
> > SELECT english || '\n' || english || '\x
On Mar 9, 2010, at 5:11 AM, Royce Ausburn wrote:
> G'day all,
>
> We recently had a bit of a catastrophe when one of our postgres databases
> opened too many files. It was a reasonably easy fix, but it did get me
> thinking. Is there a rule of thumb in determining how many file descriptors
I'm gonna take a scientific wild-assed guess that the real issue here
is caching, or more specifically, lack thereof when you first start up
your copy of the db.
[Scot Kreienkamp]
That is definitely one of the problems. No way to help that that I'm
aware of.
--
Sent via pgsql-general mailing
G'day all,
We recently had a bit of a catastrophe when one of our postgres databases
opened too many files. It was a reasonably easy fix, but it did get me
thinking. Is there a rule of thumb in determining how many file descriptors
should be available to a postgres database/cluster?
I'd be h
On Tue, Mar 9, 2010 at 1:47 PM, Scot Kreienkamp wrote:
> I found a way to do it very easily using LVM snapshots and WAL log
> shipping, but the net effect is I'm bringing a new LVM snapshot copy of
> the database out of recovery every 1-2 hours. That means I'd have to
> spend 15 minutes, or one-q
Could you have two of these non-production databases? Prepare one in the
background, including an analyze and then make it the 'live' non-production
database then use the offline / alternative database for the next load
prepare that and then switch it on when ready.
In this scenario you'd need twi
Hello,
In postgre, when i am trying to give alias name in update statement like
below -
-
update mytable x
set x.name = 'asdf'
where x.no = 1
---
is giving error - mytable is not having col x.
We have migrated code from oracle to pos
On Tuesday 09 March 2010 12:50:45 am Ian Barwick wrote:
> Hi
>
> I was wondering where some spurious information in a query was
> coming from - it looked like something was inserting all the
> values of a table row as a comma-separated list.
>
> It turns out I was attempting to reference a non-exis
John Gage wrote:
> I would like to use the following query:
>
> SELECT english || '\n' || english || '\x2028' || french AS
> output FROM vocab_words_translated;
>
> where \x2028 is the hexadecimal code for a soft carriage return.
>
> However, this does not work.
>
> Can anyone help with this p
seiliki wrote:
>>> The data types of tableout.c1 and tablein.c1 are both bytea.
[...]
>>> However, I get the following errors from log when calling
>>> libpq functions PQputCopyData() and PQputCopyEnd().
>>>
>>> 2010-03-06 20:47:42 CST ERROR: invalid byte sequence for encoding "UTF8":
>>> 0x
ISTM that 9.0's read-only standby feature may be of use to you. I know
it doesn't help you *today* but have you looked at it yet?
Okay, so the RO database won't work. How much data are we talking?
How much growth do you see between snapshots?
The initial database size is 31 gigs.
Wish I could Tom. I need a non-production, read-write copy of the
database that is updated every 1-2 hours from production. I don't set
this requirement, the business does. I just have to do it if it's
technically possible.
I found a way to do it very easily using LVM snapshots and WAL log
shippi
On Tue, Mar 9, 2010 at 10:01 AM, Scott Mead wrote:
>
> On Tue, Mar 9, 2010 at 9:56 AM, Scott Marlowe wrote:
>
>> On Tue, Mar 9, 2010 at 6:47 AM, Scot Kreienkamp
>> wrote:
>> > Wish I could Tom. I need a non-production, read-write copy of the
>> > database that is updated every 1-2 hours from pro
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Bruce replied:
...
>> This means that, even using syslog as a destination, it's not possible for
>> me to filter statements without some sort of log-text parsing, which I'd
>> prefer to avoid on effort, performance and data-integrity grounds.
>
Dear List
Is it possible to have a warm standby with 8.1? I have set up log
shipping to standby server but it seems that i cannot make it read any
subsequent
walfiles except the first one played with initial data.With pg_standy
with 8.2+ it is so easy to make it work but I would also like to have
Dear Pavel,
Thanks a lot...
It worked.
Regards,
Venkat
From:
Pavel Stehule
To:
venkatra...@tcs.com
Cc:
pgsql-nov...@postgresql.org, pgsql-general@postgresql.org
Date:
03/09/2010 04:07 PM
Subject:
Re: [GENERAL] Can we overload = operator to word numeric = text
2010/3/9 :
>
> Hello,
>
> We
2010/3/9 :
>
> Hello,
>
> We have migrated oracle database to postgre.
> In oracle char to numeric type conversion is explicit (i.e. we can compare
> char = numeric); but in postgre it is throwing errors. There are so many
> functions - around 2000, and we can not go and do explict type casting i
Hi, I have created below function. I am checking return value of
has_schema_privilege by using flag="f". I think this is not strong way to
make a check because if in future "f" becomes "false" my stored procedure
will work improper.
Could you tell me is there any other robust way to make sure that
Hello,
We have migrated oracle database to postgre.
In oracle char to numeric type conversion is explicit (i.e. we can compare
char = numeric); but in postgre it is throwing errors. There are so many
functions - around 2000, and we can not go and do explict type casting in
every function , wh
Cyril Scetbon wrote:
Does anyone know what can be the differences between linux kernels
2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !)
http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2
http://www.csamuel.org/2009/04/11/default-ext3-mode-changing-in-2630
Hi,
I refered
http://www.postgresql.org/docs/8.4/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
and
got to know that I can fetch the information about permissions on schema.
Below commands work fine:
SELECT has_schema_privilege('user1', 'mydb', 'USAGE');
SELECT has_schema_privilege('user
Hi
I was wondering where some spurious information in a query was
coming from - it looked like something was inserting all the
values of a table row as a comma-separated list.
It turns out I was attempting to reference a non-existent column
called (literally) "name", which instead of throwing an
Hmm...that would be too much work I think. Ayway, could you point me some
useful link for postgresql middleware?
Thanks.
On Tue, Mar 9, 2010 at 1:13 PM, John R Pierce wrote:
> dipti shah wrote:
>
>> What is middleware?
>>
>
> An application server that does all the business logic. your user so
75 matches
Mail list logo
