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
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-
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
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 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
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
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
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
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
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-
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
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 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
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 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
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 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
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
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
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
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 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, 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, 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
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
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
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
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
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
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
> 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
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
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 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 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: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 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 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
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
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,
>>>
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
>
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
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-
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
-
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",
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,
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
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
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
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-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
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
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
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
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
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, 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 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
58 matches
Mail list logo
