[ADMIN] View as front-end to function

Hi list, I've done some research on the subject and found only some dated threads on this topic. Wondering if anything has changed. What I am looking for is a way to create a VIEW that is a front-end to a function. Any conditions in the WHERE clause would be passed as parameters to the

[ADMIN] 32-bit to 64-bit migration options

All, I'm planning a migration for a customer with a PostgreSQL 8.4 database cluster running CentOS 4.8 32-bit. The target platform is CentOS 6.2 64-bit and will be running PostgreSQL 8.4 (our application delivers and supports 8.4, don't bother bringing up 9.x). If this were a small database

Re: [ADMIN] stats and unix sockets

On Wed, Dec 21, 2011 at 9:21 AM, Bèrto ëd Sèra berto.d.s...@gmail.comwrote: Hi! That's a pretty stupid requirement. The stats collector socket is bound to itself, so it's inaccessible from anywhere else (on machine or off) regardless of firewall settings. There's no need to worry about

Re: [ADMIN] lo_import/lo_export in other table

On Fri, Aug 12, 2011 at 12:31 PM, Nelson Gonzaga ngonz...@yahoo.com wrote: Hi all, How can I modify (or create other one) lo_import to save data in my table (not in pg_largeobject). Because I'm making an app that create a table with my fields and a bytea field, but .net doesn't read that

Re: [ADMIN] How to change all owners on all objects in a schema

On Thu, Jun 23, 2011 at 2:41 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Kevin Grittner kevin.gritt...@wicourts.gov wrote: || ' set schema newschema;' Oops; you wanted to change the owner, but I'll leave that as an exercise for the reader. :-) Beat me to it :)

[ADMIN] General migration question

Probably questions best asked on hackers but I figure many are represented here. Will there ever be a release where a dump-restore is not necessary? Perhaps, at least, minor releases (e.g. 9.0 to 9.1) will not require a dump-restore? From 9.0 Release Notes: E.1.2. Migration to Version 9.0 A

Re: [ADMIN] General migration question

On Tue, Aug 31, 2010 at 9:07 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Greg Spiegelberg's message of mar ago 31 09:04:18 -0400 2010: Probably questions best asked on hackers but I figure many are represented here. Will there ever be a release where a dump-restore is

Re: [ADMIN] High availability with Postgres

On Sun, Jun 20, 2010 at 10:36 AM, Elior Soliman elior.soli...@correlix.com wrote: Hello, My company looking for some solution for High availability with Postgres. Our optional solution is as follows : Two DB servers will be using a common external storage (with raid). Both servers are going

Re: [ADMIN] Filesystem and PG configuration

On Fri, Jun 4, 2010 at 7:53 PM, Anh Ky Huynh xky...@gmail.com wrote: A good start: Tuning: http://www.westnet.com/~gsmith/content/postgresql/pgbench-scaling.htmhttp://www.westnet.com/%7Egsmith/content/postgresql/pgbench-scaling.htm Benchmark: http://edoceo.com/liber/db-postgresql-benchmark

Re: [ADMIN] postgres invoked oom-killer

2010/5/7 Silvio Brandani silvio.brand...@tech.sdb.it Greg Spiegelberg ha scritto: Is this system a virtual machine? Greg No is not, is up and runnig from 4 months , 60 G of data in 9 different databases. Lately we import a new schema in one of those databases . Okay. I asked

Re: [ADMIN] postgres invoked oom-killer

On Fri, May 7, 2010 at 8:26 AM, Silvio Brandani silvio.brand...@tech.sdb.it wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 *** snip *** May

Re: [ADMIN] Restore database from tablespace

On Thu, Jan 28, 2010 at 4:26 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: I'm still not sure I follow, but there's a technique which isn't worth much for backup proper, but can be a good way to repeatedly get to a consistent starting point for tests in some circumstances. Look at

Re: [ADMIN] Restore database from tablespace

On Thu, Jan 28, 2010 at 9:56 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: dev.pho dev@gmail.com wrote: I was wondering if I could restore the database from the location of the tablespace. It's not clear exactly what you want to do.  Have you read through the documentation on

Re: [ADMIN] replay WAL segments without a base backup ?

On Tue, Aug 11, 2009 at 9:05 AM, Kevin Kempter kev...@consistentstate.comwrote: Hi all; due to operator error at one of my client sites we're trying to restore a deleted db. We did a restore with a pgdump that went fine but the dump is 3weeks old. they do have WAL segments and they claim

Re: [ADMIN] RAID for the DB filesystem

On Tue, Aug 4, 2009 at 2:17 AM, Brian Modra epai...@googlemail.com wrote: 2009/8/3 Scott Marlowe scott.marl...@gmail.com On Mon, Aug 3, 2009 at 10:15 AM, Brian Modrabr...@zwartberg.com wrote: Is there a valid reason you're NOT considering RAID-1 here? I hope RAID-0 is a typo. It was

Re: [ADMIN] WAL backup

On Tue, Jul 28, 2009 at 1:46 AM, Albert Shih albert.s...@obspm.fr wrote: Hi all I'm not sure I understand http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html My problem: I've huge database ~ 1To (soon 2 To) and I need backup. I can use pgdump because

Re: [ADMIN] Hard link / rsync backup strategy successful

I'm in agreement. That is a recipe for a failed recovery. If you must use some file system / volume trickery to get an initial backup then I would suggest looking into LVM or some similar volume manager. For beginners, take a look at the link below.

Re: [ADMIN] OID assistance

that capability built into it. I read a mailing list article from a while back and there was mentioned in it the possibility of OID's becoming a INT8. Does this exist in any of the new versions? Greg -- Greg Spiegelberg Product Development Manager Cranel, Incorporated. Phone: 614.318.4314 Fax

Re: [ADMIN] OID assistance

| bigint | not null default nextval('public.imgs_id_seq'::text) file | text | contents | oid| Indexes: imgs_pkey primary key btree (id) Data is loaded using INSERT's. insert into imgs values (1,'/path/to/myfile',lo_import('/path/to/myfile')); Greg -- Greg Spiegelberg Product

Re: [ADMIN] OID assistance

in the backend where OID's are managed? Second, shouldn't there be something like use WITHOUT OIDS for data warehouses be in the FAQ? Thanks for the quick response. Greg -- Greg Spiegelberg Product Development Manager Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL

Re: [ADMIN] PLEASE GOD HELP US!

archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Greg Spiegelberg Product Development Manager Cranel

Re: [ADMIN] Clustering Postgres

of the tpc style benchmarks on the system, check the archives or the osdl site for more info on getting these up and running. Robert Treat On Monday 24 May 2004 09:59, Greg Spiegelberg wrote: Robert, I am currently evaluating PolyServe Matrix Server which is a clustering solution including

Re: [ADMIN] Clustering Postgres

of how well it works. If you (or anyone else) gives it a spin please try to post an account to the list and/or if you send me the info it could probably make its way on to techdocs. Robert Treat -- Greg Spiegelberg Product Development Manager Cranel, Incorporated. Phone: 614.318.4314 Fax

Re: [ADMIN] Clustering Postgres

! | | [EMAIL PROTECTED] | Sweet! Can I have fries with that?| | 516-255-0500 | - Tom Tomorrow | +---+-+ Greg Spiegelberg wrote: Robert, I am currently evaluating PolyServe Matrix Server which

Re: [ADMIN] Postgres Admin - Export Database

have to do clear this out?? Try the pg_dump option -F t. It will create a single tar file that pg_restore can use. ./pg_dump -U username -ci -F t -f filename.tar dbname Greg -- Greg Spiegelberg Product Development Manager Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email

Re: [ADMIN] IMPORT or ETL tools

,Normal,142.130.130.19 Before doing your COPY (I'm assuming you're doing a COPY) have you done a set datestyle to 'European';? -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity

Re: [ADMIN] Hardware for a database server

with UPS, auto-shutdown before power fails, so do I need my RAID controller battery-backed still? Yep. Power supplies fail, motherboards fry and take out the power rail every so often. Idiots trip over power cords. hehe. been there, done that, got the TShirt. Double ditto. -- Greg Spiegelberg

Re: [ADMIN] syslog slowing the database?

Tom Lane wrote: Greg Spiegelberg [EMAIL PROTECTED] writes: I turned syslog back on and the restore slowed down again. Turned it off and it sped right back up. We have heard reports before of syslog being quite slow. What platform are you on exactly? Does Richard's suggestion of turning off

[ADMIN] Linux Cluster File Systems

Anyone have good/bad experience using OpenGFS or the Sistina GFS? Any other cluster file systems out there? Greg -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus

Re: [ADMIN] UNIX File buffering disable?

what they're talking about? You can't (AFAIK), and you don't need to. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Greg Spiegelberg

[ADMIN] Reindex database

Any rule of thumb for REINDEX DATABASE? Once per month? Per x transactions? -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus. ---(end

Re: [ADMIN] Postgresql DB on a live cd

---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax

[ADMIN] Moving Database Directory

-- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus. ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Upgrading to Solaris 9

time. -= IMHO =- The short answer to your question is yes, it will run on Solaris 9. Greg Peter Eisentraut wrote: Danielle Cossette writes: Could you please let me know if Postgres 7.1.3 will run on Solaris 9. Why don't you try it out? -- Greg Spiegelberg Sr. Product Development Engineer

[ADMIN] Locks

Is there a good all-inclusive resource out there that documents LOCK in PostgreSQL, any side-effects when used, and how UPDATE, DELETE, cursors, transactions, and so on use them? Thanks, Greg -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax

[ADMIN] Multiple databases

it needs to either (1) start a new instance of PostgreSQL listening on 5432/tcp but bound to a different IP or (2) the current PostgreSQL imports the databases under /pg/dataA Each have their good points and problematic issues. Thoughts? Greg -- Greg Spiegelberg Sr. Product Development

Re: [ADMIN] libpq problem

-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus

Re: [ADMIN] \connect ...ing since a dbserver to another

most insert rows from a box (192.168.1.1_db1 to another 192.168.1.2_db2). Thanks in advance Eduardo Caillava [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email

Re: [ADMIN] Starting postgres on Solaris

)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus. ---(end of broadcast

[ADMIN] Vacuum Memory Exhausted error

non-system, non-postgres tables, then perform the vacuum on each non-system, non-postgres table, and finally recreate the indexes. The reindex every 6 hours is currently disabled as well. This is the only solution I have to date. Any input would be greatly appreciated. Greg -- Greg Spiegelberg Sr

[ADMIN] Linux system panic

Hello, I have a Redhat 7.3 system with PostgreSQL 7.2.3 and when I run some jobs I have to add data to the databases running the system slows, the file system where PGDATA resides fills up and all of memory and disk swap gets used up... then panic. There is nothing in any of the log files, we're