Re: [GENERAL] hardware failure - data recovery

)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144

Re: [GENERAL] Discover temporary INDEX/TABLE name

-- --- Jerry Sievers 305 854-3001 (home) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant ---(end of broadcast)--- TIP 1: if posting

Re: [GENERAL] statement_timeout

to 0; Pozdrawiam Marcin Mañk ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ -- --- Jerry

Re: [GENERAL] Stuck in DELETE waiting

. -- --- Jerry Sievers 305 854-3001 (home) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant ---(end of broadcast)--- TIP 1: if posting

Re: [GENERAL] How to unlock a row

-- --- Jerry Sievers 305 854-3001 (home) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] TRIGGER BEFORE INSERT

---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ -- --- Jerry Sievers 305 854-3001 (home) Production Database

[GENERAL] Adding domain type with CHECK constraints slow on large table

, this hackery would save hours of downtime on a prod system. Comments? PS: Sent this a few hours ago and never saw it. Sorry if duplicate. -- --- Jerry Sievers 732 365-2844 (work) Production Database

Re: [GENERAL] Adding domain type with CHECK constraints slow on large table

Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] writes: I believe what's happening here is that the server doesn't realize that the new column is going to have all nulls and that the check constraint allows nulls. As such, the check evidently is being evaluated

[GENERAL] Easier string concat in PL funcs?

; $$, array [ v_tablename, v_rulename, v_tablename, v_conditions ], '%' ); -- ...Still not exactly simple, I realize :-) Thanks --- Jerry Sievers 732 365-2844 (work) Production

[GENERAL] Perhaps silly question about empty search_path

are now connected to database jerry. [EMAIL PROTECTED] = show search_path; search_path - (1 row) [EMAIL PROTECTED] = -- --- Jerry Sievers 732 365-2844 (work) Production Database Administrator

Re: [GENERAL] Perhaps silly question about empty search_path

Jerry Sievers [EMAIL PROTECTED] writes: Hello; To begin with, I'm not certain how useful it would be... that said; it seems odd that a role or DB can have it's config search_path set to empty string but you can't explicitly set it that way. Ugh! Sorry. I forgot to see if set_config

Re: [GENERAL] INSERT OR UPDATE?

exists already and if so, do an update inside the trigger function and return null else return new and the outter query proceed doing the insert. HTH -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant

Re: [GENERAL] INSERT OR UPDATE?

rows) HTH -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast

Re: [GENERAL] A good client

the open-source RDBMS least heavily used by Weenies!/SnobMode And as another list member has already pointed out, the GUI admin tools are continuing to improve. Thanks -- --- Jerry Sievers 305 854-3001 (home) WWW

Re: [GENERAL] getting around---division by zero on numeric

-- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 6: explain analyze is your

Re: [GENERAL] Updating within Triggers

-- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] A Not Join

join the userids with permids and then EXCEPT SELECT from linkage table to filter out the active permissions. Have fun! -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144

Re: [GENERAL] how to emit line number in a function?

debugging headaches if not used artfully! HTH -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end

Re: [GENERAL] Changing ids conflicting with serial values?

set new.id to old.id thereby insuring that it can't be changed. create function no_pkey_update() returns trigger as ' begin new.id = old.id; return new; end' language plpgsql; HTH -- --- Jerry Sievers

[GENERAL] Connections over SSH tunnels closing after idle time

combinations of the SSH TCP keepalive and ServerAlive settings. Any advice how to solve or better drill down to the exact problem is much appreciated. Thanks -- --- Jerry Sievers 732 365-2844 (work) Production Database

[GENERAL] Autovac _scale_ settings not changed by SIGHUP?

-- --- Jerry Sievers 732 365-2844 (work) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [GENERAL] Join field values

is already provided. select array_to_string(array(select * from generate_series(1,5)), ','); array_to_string - 1,2,3,4,5 (1 row) Help to write SELECT-query for this task. -- --- Jerry Sievers 732 365-2844

[GENERAL] Postgres jobs mailing list?

. -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 3: if posting

Re: [GENERAL] Hosting Service Recommendations

-- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose

[GENERAL] CSV delim quoting differences PgCOPY, Excel etc...

psql \copy? I fail to read in the docs for the Pg products any support for this. If Excel can adapt, at least one experienced user I've asked, doesn't know about it. Thanks. -- --- Jerry Sievers 305 854-3001 (home) WWW

[GENERAL] pg_temp_N temp schema buildup

after use? Thanks. -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast

Re: [GENERAL] Rule appears not to fire on insert w/ except

on. Not SQL but see config setting; debug_print_rewritten -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com

Re: [GENERAL] pg_connect troubles on localhost

. See comments in both files and the Postgres docs as well for more info. HTH -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com

Re: [GENERAL] How to check options PostgreSQL was started with

'pg_ctl start' all you'll get is the path to the postmaster or postgres executable. OTOH, 'pg_ctl -o-F start' and the path plus your -F option will show up there. HTH -- --- Jerry Sievers 305 854-3001 (home) WWW

Re: [GENERAL] PostgresSQL Halting System Boot

waiting. $ pg_ctl start /dev/null Or... $ echo n | pg_ctl start If any of these workarounds suffice, edit them into your /etc/init.d/postgresql script. HTH -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce

[GENERAL] 8.1 build on Solaris has LATIN9?

we import the original DBs with LATIN1 encoding. I saw a message already during an import to the effect of can't do conversion... Thanks -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant

Re: [GENERAL] 8.1 build on Solaris has LATIN9?

Please forgive the empty reply preceeding this note. Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] writes: Hi. I am curious how/why the Pg 8.1.1 build on Solaris SunOS $hostname 5.9 Generic sun4u sparc SUNW,Ultra-250 chose LATIN9 charset as default

[GENERAL]

Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 8.1 build on Solaris has LATIN9? References: [EMAIL PROTECTED] [EMAIL PROTECTED] From: Jerry Sievers [EMAIL PROTECTED] Date: 16 Dec 2005 16:42:37 -0500 In-Reply-To: Tom Lane's message of Fri, 16 Dec 2005 15:28:43 -0500 Message-ID: [EMAIL

Re: [GENERAL] Checking for Foreign Keys constraining a record?

to the trans. begin; set log_min_messages to log; do trial delete; rollback; HTH -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com

Re: [GENERAL] Checking for Foreign Keys constraining a record?

Forgot to add; another option is to use a PL function with an exception handler. This may be a bit more elegant approach but not necessarily easier. FYI Jerry Sievers [EMAIL PROTECTED] writes: Benjamin Smith [EMAIL PROTECTED] writes: I want to be able to determine in advance whether

[GENERAL] psql \echo strangeness with :variables

-- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [GENERAL] why cannot UNION both SELECT and SHOW?

-+- $user,public | PostgreSQL 9.0.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 64-bit (1 row) Thx -- Jerry Sievers Postgres DBA/Development Consulting e

Re: [GENERAL] Vacuum as easily obtained locks

that is not an issue for getting the AccessExclusiveLock on the table? You are certain that those clients do these quick select as auto-commit? What does select current_query from pg_stat_activity say? -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p

Re: [GENERAL] failed to start postgresql service

. Or try; pg_ctl -D /usr/local/pgsql/data start -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Postgresql problem with update double precision

of postgresql, Im now use 9.0.3 Anyone know what can be the problem and why some times records is fine, some times isnt ? That floating point data types are inexact is a well known problem with them and not Postgres specific. Consider switching those fields to type NUMERIC. HTH -- Jerry Sievers

Re: [GENERAL] Select count with offset returns nothing.

Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list

Re: [GENERAL] altering foreign key without a table scan

subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Feature request: per user connections limit

@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] pg_lock_status not documented

Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA

Re: [GENERAL] Am I best off keeping large chunks of text in a separate table?

. YMMV Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via

Re: [GENERAL] CLONE DATABASE (with copy on write?)

://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Exporting 1 text column from all rows from a table to a file per row?

to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] plpgsql Difference in behaviour between versions?

/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] plpgsql Difference in behaviour between versions?

they would not be syntactically valid. RETURN; END; $$ LANGUAGE plpgsql; ===snip=== -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA

Re: [GENERAL] queries timeout during backup postgres database

and what statement is running if any when canceled? Regards -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Update takes longer than expected

instantaneously. Migrate from MySQL to Postgres? Good idea. Keep the faith :-) HTH Cheers, Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA

Re: [GENERAL] Redirect ERROR, FATAL and other messages

://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

[GENERAL] Parameter setting in multi-statement command; I got bit today

sorts of code into a single execute(). Along these lines, I'd be curious to know of other good reasong for *not* combining statements like this. Thanks -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 732.216.7255 -- Sent via pgsql-general mailing list

Re: [GENERAL] Parameter setting in multi-statement command; I got bit today

Tom Lane t...@sss.pgh.pa.us writes: Jerry Sievers gsiever...@comcast.net writes: Just FYI... maybe I'm the only Pg veteran who didn't know this but; Parameter settings in a multi-statement command are not in effect for later statements in same command. This is not a true statement

Re: [GENERAL] Bug? Prepared queries continue to use search_path from their preparation time

to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers e: jerry.siev...@comcast.net p: 732.216.7255 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Bug? Prepared queries continue to use search_path from their preparation time

to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers e: jerry.siev...@comcast.net p: 732.216.7255 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Database Bloat

in the remarks by others on this thread but worth verifying. Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e

Re: [GENERAL] SELECT count(*) differs from result in pgadmin

, but why am I getting the wrong number from SELECT Count(*)? -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Trigger function on Warm Standby

will never happen on the Standby server? Is it expected or am I missing some other settings? It will not fire on a standby. Thanks~ Ning -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql

[GENERAL] Dump/Reload pg_statistic to cut time from pg_upgrade?

: COPY pg_statistic, line 1, column stavalues1: {_assets,_income,_liabilities,assets,income,liabilities} Setting allow_system_table_mods to 'on' is required also prior to attempting the import. Has anyone else attempted anything similar? Any feedback is appreciated. Thanks -- Jerry Sievers

Re: [GENERAL] TOC errors

Thank you, Perry -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_stat_replication became empty suddenly

000100120005 has already Raise wal_keep_segments on your master configs ,and HUP and/or start your standby a lot sooner after it's reloaded. snip -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general

Re: [GENERAL] OLAP

-- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA

Re: [GENERAL] validate synatax

) 4.7.2, 64-bit (1 row) Best, Peter -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Replication failed after stalling

to variations in how quickly WAL segments are filled and cycled over. HTH Joe -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] index and table corruption

this way however with something wide-ranging such as an all-table vac/analyze, dumpall... etc, soon after launching the foo, corruption was observed. FWIW Will update once we get onto the new h/w to see if that fixes it. Thanks, Karthik -- Jerry Sievers Postgres DBA/Development Consulting e

Re: [GENERAL] subtracting from a date

-01'::date - interval '1 day'; ? ? ? ?column? - ?2013-03-31 00:00:00 You did say what language you are using for the function so the assignment will depend on that. thanks -- Adrian Klaver adrian.kla...@gmail.com -- Jerry Sievers

Re: [GENERAL] pg_restore issue

-- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] What could keep a connection / query alive?

. SIGTERM on such a backend will probably also fall on deaf ears. This has been my experience several times in an environment of EnterpriseDB 8.2 systems on Solaris 10. YMMV -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Autocommit off - commits/rollbacks

the whole transaction after an error? It's a PostgreSQL limitation (or, arguably, optimization). When a Well, any transactional RDBMS whatsoever should behave that way. Hardly a PostgreSQL exclusive feature :-) -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general

Re: [GENERAL] stack depth limit exceeded

the server configuration [snip] I'd strongly suspect a case of infinite recursion. Have you ruled that out first? You might try incrementing a sequence in the function during one of the bad runs to see how deep it's recursing. -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever

Re: [GENERAL] Access to NEW.column outside of a trigger function.

(not write, just read) the NEW.column values that a trigger function would normally have access to? Sure. Just pass them into your validator func as parameters. But why are you avoiding use of a trigger here? Thanks in Advance for any help. -- Jerry Sievers Postgres DBA/Development Consulting e

Re: [GENERAL] Sequence names have 64 character limit?

convention of the PG default table_column_seq. Yes, I know that its not a great idea to depend on consistent naming conventions! Carlo -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Sequence names have 64 character limit?

the text to regclass to an OID... but this stuff makes me nervous. Nervous or otherwise, if your sequences are owned by the tables either by their implicit creation with SERIAL keyword or a later ALTER SEQUENCE OWNED BY, then querying the class and depend catalogues is your most reliable bet. -- Jerry

Re: [GENERAL] Table lock while adding a column and clients are logged in

-- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Table lock while adding a column and clients are logged in

Jerry Sievers gsiever...@comcast.net writes: Sven Haag sven-h...@gmx.de writes: hello pg fans, we have an application that communicates via ODBC directly to the postgres database. if i'm trying to add an additional column to a table in pgadmin while clients are logged in, pgadmin hangs

Re: [GENERAL] Dumping functions with pg_dump

a specific function? Just do; pg_dump --schema-only Go find the function definition in the output script, snip it out and load with psql. Remember to load it into the correct schema and whatever other details. HTH -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql

Re: [GENERAL] Auto Adjust Age

suggest not storing age but instead wrapping with a view that calls date_trunc('year', now() - dob). If you must store the age then you have to run a daily batch to make the bulk update. HTH -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Deferred foreign key constraint downsides

. Why promote being able to insert rows in related tables using other than top-down sequencing? Sure, if you have an existing app that does that, which you can't change, go with deferred validation, otherwise no. YMMV Thanks. -- Jack Christensen ja...@hylesanderson.edu -- Jerry Sievers e

Re: [GENERAL] Calculating memory allocaiton per process

bet. HTH Something similar to Table 17-2 here: http://www.postgresql.org/docs/9.0/interactive/kernel-resources.html would be awesome. Dave -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] How can you have an Exclusive Lock on nothing? please help me understand this lock monitoring query output

| user || 2011-04-14 17:36:01.257669-07 | 00:21:28.847825 | 16798 Thanks, Aleksey -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] How to silence constraint violation logging for an INSERT

; Cheers, Paul. -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to silence constraint violation logging for an INSERT

Andrew Sullivan a...@crankycanuck.ca writes: On Fri, Apr 15, 2011 at 02:04:49PM -0400, Jerry Sievers wrote: set log_min_messages to fatal; I thought changing the log_min_messages required superuser access? (That's what the docs say, and what I'd expect too.) Oops!... Yup. Forgot about

Re: [GENERAL] vacuumdb with cronjob needs password since 9.0?

at setting the pw in the .pgpass file for the invoking user. If you insist on doing it on cmd line; try; PGPASSWORD=foo vacuumdb ... HTH -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Column names getting lower-case in SELECT statements when issued via JDBC

for help in advance. -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [ADMIN] Unable to reload postgresql.conf without restarting

posgres 9.1 on Centos Linux (amazon ec2) Thanks -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Discerning when functions had execute revoked from public

? Apologies if this should be obvious. I'm sure I will find it as soon as I hit send. :-) thanks, -Todd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres

Re: [GENERAL] psql copy from through bash

pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list

Re: [GENERAL] restoring to different architecture with WAL

DETAIL: ?The database cluster was initialized with USE_FLOAT8_BYVAL but the server was compiled without USE_FLOAT8_BYVAL. 2013-03-07 22:11:16 CET HINT: ?It looks like you need to recompile or initdb. -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p

Re: [GENERAL] create temporary table problem

directory pg_tblspc/16385/PG_9.0_201008051/20304: No such file or directory The same query work in PGSQL 8.0 Please guide me. Regards, J Prasanna Venkatesan -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general

Re: [GENERAL] Facing difficulty in PITR

are and move them into place. HTH Thanks in advance.Any?suggestions?would be?appreciated. Regards, Chiru -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Save postgresql node to catch only DML except delete queries

(pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] log_statement per table

insert or update or delete on foo execute procedure foo(); commit; insert into foo select 1; -- David Janssens -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] archiving transaction log file failed too many times, will try again later

command was: false 2014-05-23 10:58:58 CEST WARNING: archiving transaction log file 0001000C failed too many times, will try again later How can I fix this? Thanks, Basti -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800

Re: [GENERAL] Downtime-free 'alter table set tablespace'

that needs moving and this will get you through it with very low downtime or possibly none if you're clever and careful. Learning how to configure and work with either of these solutions unfortunately takes a bit of work. Thanks. -- Vincent de Phily -- Jerry Sievers Postgres DBA/Development

Re: [GENERAL] Postgresql 9.2.4 - timezone error

Bhushan Pathak -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] what does pg_activity mean when the database is stuck?

Strategies, Inc. sic...@opensourcestrategies.com http://www.OpenSourceStrategies.com LinkedIn: http://www.linkedin.com/in/opentaps Twitter: http://twitter.com/opentaps -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general

Re: [GENERAL] Alternative to psql -c ?

executor calls are somewhat nuanced in their own ways and I would be trying hard *not* to do this without very good reason. Regards, James -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] how to create a role with no privileges?

not correspond to any real role.  Its purpose, rather, is to serve as the starting point for defining more realistic roles by selectively adding the fewest privileges possible). TIA for any pointers! kynn -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult

Re: [GENERAL] Best way to list a roles owned objects?

possible for you to easily identify such items later rather then have them mixed up with everything postgres owns. The assumption is, that many of the things so reassigned are quite possibly junk, given that the real owner has been dropped from the system. -F -- Jerry Sievers Postgres DBA

  1   2   >