On Thu, Jul 23, 2009 at 08:45, Steffen Kuhn wrote:
> Hallo Knut,
>
> this is right see following link for details about enterpriseDB
> installers and provided features
> http://www.enterprisedb.com/products/postgres_plus/overview.do#ui-tabs-6
> 8
That page refers to the Postgres Plus product. The
Hi, folks?
I'm hoping this is the right mailing list for this sort of question. If not,
I apologize you
any inconvenience in advance, though.
I'm trying to set up postgreql 8.3 in a box running Ubuntu 8.04 and PSQL 8.3
Thisbox is sort of misconfigured because it has 15GB for / and 3 TB for
/home.
On Thu, Jul 23, 2009 at 8:06 AM, Magnus Hagander wrote:
> On Thu, Jul 23, 2009 at 08:45, Steffen Kuhn wrote:
>> Hallo Knut,
>>
>> this is right see following link for details about enterpriseDB
>> installers and provided features
>> http://www.enterprisedb.com/products/postgres_plus/overview.do#ui-
Hi,
I set synchronous_commit to off and expected trivial inserts (single row,
6-8 columns) to always return quickly. However, I see that during
checkpoints they sometimes take over a second. I tried setting the
full_page_write to off, but this didn't seem to have an effect.
The version I'm using
trying to run
postgresql-8.4.0-1-windows.exe
as a user without admin-privs leads to:
"PostgreSQL has detected a problem and has to be ended" (on german)
Problem-Signator:
AppName: postgresql-8.4.0-1 -windows.exe
ModVer: 1.0.0.0
Offset: 0004df8b
the same also happens when only trying to read th
Andrew Klaassen wrote:
> Is it possible to get table.column in query results rather
> than just column?
>
> I.e. I'd like:
>
> SELECT * FROM foo, bar;
> foo.id | foo.name | bar.id | bar.text
> ---+--++-
> ...
>
> ...rather than:
>
> SELECT * FROM foo, bar;
> id | na
groovefillet wrote:
> Is it possible to set the runtime parameter 'join_collapse_limit' for
> a single query only without setting/unsetting it before/after?
Yes:
START TRANSACTION;
SET LOCAL join_collapse_limit = 42;
SELECT .
COMMIT;
Yours,
Laurenz Albe
--
Sent via pgsql-general maili
On 2009-07-14, Jim Michaels wrote:
>
> --0-1060148048-1247615236=:84835
> Content-Type: text/plain; charset=us-ascii
>
> I am having problems with pg_restore. pg_restore
> --file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
> --username=postgres
>
> this just hangs.
> I a
On 2009-07-20, APseudoUtopia wrote:
> --001636c5b16936e279046f2a9776
> Content-Type: text/plain; charset=UTF-8
> Content-Transfer-Encoding: 7bit
>
> Hey,
>
> I'm writing a backup script. Right now, I only have one database on my
> postgresql server. I'm deciding if I should use pg_dump or pg_dumpa
On 2009-07-22, Andrew Klaassen wrote:
> Hi,
>
> Is it possible to get table.column in query results rather than just column?
it is possible to get the OID of the table from libpq.
I don't think psql provides display of the table name as a
formatting option, and most wrapper around libpq seem to
Hi,
My colleage Geard Troost and I found a handy way of comparing OLD and
NEW in a trigger function.
Normally this does not work (if anyone can tell me why, that'd be
great), but once you cast them to text, it does.
Is there anything to say against this, or can i go ahead and recommend
this to ev
Hi,
I'm getting the following error from my Postgres database while inserting:
ERROR: unexpected data beyond EOF in block of relation "RelationName".
My configuration is:
openSUSE 11.1
Linux linux-wsr1 2.6.27.23-0.1-default #1 SMP 2009-05-26 17:02:05 -0400 x86_64
x86_64 x86_64 GNU/Linux
Postgr
Hello
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
regards
Pavel Stehule
2009/7/23 Willy-Bas Loos :
> Hi,
>
> My colleage Geard Troost and I found a handy way of comparing OLD and
> NEW in a trigger function.
> Normally this does n
Hi guys,
I have a program that I need compile using PostgreSQL 8.4.0 (or later) and
it must be able to run on an 8.3.5 based system as well as 8.4.0. I'm using
embedded SQL for C and I have the following sequence of statements:
snprintf( stmt, 3000, "SELECT count(*) FROM %s WHERE %s",
Pavel Stehule, 23.07.2009 13:45:
Hello
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
regards
Pavel Stehule
That collection of tips is really nice.
Why isn't there a link from the Postgres Wiki to your page?
Regards
Thomas
-
Pavel Stehule schrieb:
Hello
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
regards
Pavel Stehule
Pavel, this trick-list is awesome ;-) Thanks for the tip!
Cheers
Andy
P.S.: a link to that would be nice ;-)
--
Sent via pgsql-
Jong Chun Park wrote:
> > sudo mkdir /home/pgsql
> > sudo mkdir /home/pgsql/data
> > sudo chown postgres /home/pgsql/data
> > sudo mkdir /home/pgsql/ts
> > sudo chown postgres /home/pgsql/ts
> > sudo su - postgres
> > initdb -D /home/pgsql/data
> > pg_ctl -D /home/pgsql/data -l logfile sta
2009/7/23 Andreas Wenk :
> Pavel Stehule schrieb:
>>
>> Hello
>>
>>
>> http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
>>
>> regards
>> Pavel Stehule
>>
>
> Pavel, this trick-list is awesome ;-) Thanks for the tip!
>
> Cheers
>
> Andy
>
Dave,
Are there any plans to add the plug-ins that were available in the 8.3
install to the stackbuilder component?
Best Regards
Michael Gould
"Dave Page" wrote:
> On Thu, Jul 23, 2009 at 8:06 AM, Magnus Hagander
wrote:
>> On Thu, Jul 23, 2009 at 08:45, Steffen Kuhn
wrote:
>>> Hallo Knut,
>>>
Pavel Stehule, 23.07.2009 14:50:
look on http://wiki.postgresql.org/wiki/Category:Snippets
That page is not accessible from the Wiki's main page (at least I can't find an
easy way to navigate there)
I think there should be a prominent link right at the start page that links to
that page and
On Thu, Jul 23, 2009 at 10:47:40AM +, Jasen Betts wrote:
> I find that jed is powerful, fast, and reasonably easy to use. and had
> no problem with 2.3MB lines.
>
> gnome-text-editor ("gedit") handles lines of tens of thousands of
> characters OK but seems to have problems displaying million
On Thu, Jul 23, 2009 at 7:45 AM, Pavel Stehule wrote:
> Hello
>
> http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
note: in PostgreSQL 8.4, you can compare record variables directly
with standard boolean operators.
merlin
--
Sent via
On Thu, Jul 23, 2009 at 01:08:26AM -0600, Jong Chun Park wrote:
> I need to configure PSQL to store all DB-related data into
> /home/pgsql/data instead of somewhere in / such as /var/lib/
> postgresql/8.3/... or /usr/local/pgsql/data.
Assuming you're using the standard builds in Ubuntu, I'd probab
On Tue, Jul 14, 2009 at 5:47 PM, Jim Michaels wrote:
> I am having problems with pg_restore. pg_restore
> --file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
> --username=postgres
>
> this just hangs.
> I am restoring from 8.3.7 to 8.4 - what did I do wrong?
>
> could somebo
On Thu, Jul 23, 2009 at 01:45:36PM +0200, Pavel Stehule wrote:
> http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks
Just had a quick flick through your list and one of the early ones stuck
out:
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Attention_on_IS_NULL_and_IS_NOT_NULL_oper
On Thu, Jul 23, 2009 at 07:40:18AM -0600, Scott Marlowe wrote:
> On Tue, Jul 14, 2009 at 5:47 PM, Jim Michaels wrote:
> > could somebody rewrite pg_dumpall and pg_dump so that it makes editable
> > dumps?
> > most programmer's text editors can't handle more than 2000
> > characters per line. and I
On Tue, Jun 30, 2009 at 11:21 PM, Scott Ribe wrote:
> Shut down the postmasters and rsync. (Assuming same architecture & build
> options...)
>
You mean rsync the "data" folder, or the entire PG folder?
Architecture may be the same (same processor) but the setup is a touch
different: SCSI hard d
> You mean rsync the "data" folder, or the entire PG folder?
I meant the data folder.
> Will this be a challenge?
Yes, if you're using different major PG releases, then the data files are
not binary compatible.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567
2009/7/23 Merlin Moncure :
> On Thu, Jul 23, 2009 at 7:45 AM, Pavel Stehule wrote:
>> Hello
>>
>> http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
>
> note: in PostgreSQL 8.4, you can compare record variables directly
> with standard bool
tomrevam writes:
> I set synchronous_commit to off and expected trivial inserts (single row,
> 6-8 columns) to always return quickly. However, I see that during
> checkpoints they sometimes take over a second.
What sort of disk hardware have you got? It sounds overstressed.
It might help to inc
Marcin Gon writes:
> I'm getting the following error from my Postgres database while inserting:
> ERROR: unexpected data beyond EOF in block of relation "RelationName".
You omitted the HINT that says this has only been known to occur in
connection with buggy kernels. I see you're running a fai
Given the situation where a user connecting to the database needs access to two
separate schemas: the primary schema which contains the data they will be
updating and a second schema which contains read-only reference data, used by
many users, that will be using in joins on queries.
I don't wan
I wonder if you could please help me out to extract a character string
to an array or better yet, a table.
I'd like to split strings of text up into words and delimiters (but
not delete the delimiters). The delimiters are defined as comma,
space, dot, singe/double quotation mark, question mark et
Hi, and thanks for the reply.
We're issuing queries from within our application where transactions
span a whole unit of work, so wrapping a single query in a transaction
just to set the param isn't really feasible except on a separate
connection, which i am loathe to do.
I was really hopi
On Thu, Jul 23, 2009 at 3:14 PM, Sam Mason wrote:
> On Thu, Jul 23, 2009 at 07:40:18AM -0600, Scott Marlowe wrote:
>> On Tue, Jul 14, 2009 at 5:47 PM, Jim Michaels wrote:
>> > could somebody rewrite pg_dumpall and pg_dump so that it makes editable
>> > dumps?
>> > most programmer's text editors can
On Thu, Jul 23, 2009 at 01:40:45PM +0200, Willy-Bas Loos wrote:
> Is there anything to say against this, or can i go ahead and recommend
> this to everyone who wants to check if anything changed before doing
> what their update triggers do?
Perhaps 8.4's suppress_redundant_updates_trigger() could
--- On Thu, 7/23/09, Albe Laurenz wrote:
> Andrew Klaassen wrote:
> > Is it possible to get table.column in query results
> rather
> > than just column?
> >
> > I.e. I'd like:
> >
> > SELECT * FROM foo, bar;
> > foo.id | foo.name | bar.id | bar.text
> > ---+--++-
>
On Thu, 23 Jul 2009, tomrevam wrote:
bgwriter_delay = 20ms # 10-1ms between rounds
bgwriter_lru_maxpages = 1000# 0-1000 max buffers written/round
bgwriter_lru_multiplier = 5.0 # 0-10.0 multipler on buffers
scanned/round
These settings may be contrib
On Tue, 21 Jul 2009 15:32:07 -0400
Merlin Moncure wrote:
> 2009/7/21 Bjørn T Johansen :
> > I have had som problem with my filesystem and now I get these error
> > messsages when trying to access my database..:
> >
> > ERROR: could not access status of transaction 2495690984
> > Could not open
I am working for a small company that is going through a PCI DSS
audit. The auditor wants to know how long the key lengths are for
the fields that we have encrypted with pgcrypto 3des. I am by no
means an expert in cryptology, so I am struggling with what to tell
him?I've done a day
All:
Any suggestions on how-to, or comments on a potential NFR, to disable
non-superuser's from viewing the database list via \l?
Possibly a postgresql.conf toggle or restrictions on the internal views
that constitute say, 'pg_catalog.pg_database'.
Something equivalent, in principal, to Free
On Tue, 21 Jul 2009, Merlin Moncure wrote:
One way to suppress this error, but not fix the underlying corruption,
is to generate clog files that the database thinks should be there.
Make a 256k file filled with 0x55 and put it where the database is
expecting.
Here's a list of past messages on
On Mon, 20 Jul 2009, Christophe wrote:
On Jul 20, 2009, at 6:56 PM, Dennis Gearon wrote:
I once talked to a company that made a custome version of Postgres. It
split tables up on columns and also by rows, had some other custome
features. It was enormously faster from what I gathered.
I cou
On Thu, Jul 23, 2009 at 6:11 PM, bulk wrote:
> 1) What are the default 3des key lengths when you load postgresql
> enterprise db on a redhat ES x86_64 box?
Traditionally 3des can use either 112-bit or 56-bit keys. I think the
openssl interface actually lets you set the third key separately now
b
Hi all,
I have some issues to compile uuid contrib of 8.4 version.
Touching something i see that the gmake don't find uuid.h.
(pfexec gmake -d)
Touching more, i add uuid.h into the uuid directory and i had a
error message: missing separator.
So i google a little and i find something:
http://www.
On Jul 23, 2009, at 10:11 AM, bulk wrote:
I am working for a small company that is going through a PCI DSS
audit.
securitymetrics.com? (They seem to be the low bidder, with everything
that implies. They asked me to open up my firewall to them, pointing
at a fake server, just so they'd ha
On Jul 23, 2009, at 12:11 PM, Steve Atkins wrote:
4) Is is possible to compile C or Java code that will allow me to
be the only one whom knows the pass-key but allow other users to
encrypt/decrypt data?
Yes, that's asymmetric cryptography, using something like DSA.
Oops. Missed the "
On Jul 23, 2009, at 12:11 PM, Steve Atkins wrote:
They asked me to open up my firewall to them, pointing at a fake
server, just so they'd have something to audit, after failing our
audit "because we only allowed access to the application from inside
our firewall."
I'm glad it wasn't just
Yes, it's working now. I appreciate your help. The problem was to not stoppsql
process even before doing anything.
Thanks a lot,
Jong
On Thu, Jul 23, 2009 at 7:38 AM, Sam Mason wrote:
> On Thu, Jul 23, 2009 at 01:08:26AM -0600, Jong Chun Park wrote:
> > I need to configure PSQL to store all DB-
Also try Netezza, one data warehouse appliance originally based on Postgres.
Although this is not the only such Postgres derivative.
Cheers,
Brent Wood
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> Greg Smith 07/24/09 9:10 AM >>>
On Mon, 20 Jul 2009, Christophe wrote:
> O
Hi All,
I have some questions for you about the best way to handle permission on
a database in a production system.
The final goal is to have a web application connected to the db using a
single user that must run select/delete/insert/update (and maybe truncate)
In my opinion that user should
On Thu, Jul 23, 2009 at 10:09 PM, Stefano
Nichele wrote:
> 2. using the user used in step 1, create the schema and populate tables with
> At this point the webapp should work correctly.
> The main missing point for me is how to perform step 4 in a simple way since
> it seems there is not a way to
I've got several columns in my database that need to have case insensitive
searches done so I've loaded the citext control module and have changed the
data types to citext. When I create a index on a column that is defined as
a citext, how is that going to be treated. Will Postgres use the index
I am using pg_standby to set up a warm standby.
Everything seems to be working OK so far but I do have one question.
I wanted to check to make sure that the replication was happening so I
created the trigger file which put the database to "live"mode. I ran
a query on the standby to make sure the
Tom Lane-2 wrote:
>
>
> What sort of disk hardware have you got? It sounds overstressed.
>
> It might help to increase wal_buffers.
>
>
The disk is a SATA drive and it will be replaced in future projects with a
better drive. However, I still don't understand why there is any halt in the
c
I must be tired. Any suggestions on converting the following to postgresql?
UPDATE IGNORE yose5_user_newflags AS flags, yose5_messages AS
msg SET flags.forum_id = msg.forum_id WHERE flags.message_id =
msg.message_id AND flags.message_id IN (15580, 15581, 15706,
15712, 15713, 15719, 15888)
--
Se
Hello.
I use postgres on windows and try setup warm standby. For
restore_command i use pg_standby program. When i try to stop postgres
service, that runs in recovery mod, service not stopping correctly,
because pg_standby still works.
Thanks.
--
Sent via pgsql-general mailing list (pgsql-
Matthew Seaborn wrote:
> Given the situation where a user connecting to the database
> needs access to two separate schemas: the primary schema
> which contains the data they will be updating and a second
> schema which contains read-only reference data, used by many
> users, that will be using
58 matches
Mail list logo
