[ADMIN] an atypical pg_restore?

Hi: I'm in the midst of upgrading from 8.1.5 to 8.2.1 usng pg_dumpall and pg_restore. My database is about 95 G in size and contains several very large tables having indexed columns of the geometry datatype (PostGis). Otherwise, my database is pretty conventional. My problem: the restore is ta

[ADMIN] pg_restore speed

Hi: I have a 90G postgis-enabled postgresql database that I'm upgrading from 8.1.5 to 8.2.1. I initiated pg_restore nearly six days ago and it's still churning away, surely but slowly. Is this amount of time normal? Or have I done something wrong? Any help is appreciated! Thanks --

[ADMIN] pg_dump: COPY vs INSERT

Hi: When I try 'pg_dump -f output.txt -t -d ', output.txt is always filled with INSERT statements. The same holds true if I use the '-a' option as well. How can I configure pg_dump to output a file I can use with COPY instead? Thanks as always! ---(end of broadca

[ADMIN] strange system columns

Hi: I use v8.1.0, and have a table named pressure: Table "public.pressure" Column |Type | Modifiers --+-+---

[ADMIN] ssl and/or md5 encryption

Hi: I specify md5 encryption in my pg_hba.conf file. Would using SSL on top of this be overkill? Thanks ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] fsm allocation

Hi I manage a moderately large database (version 8.0.4) that experiences about 500 inserts per hour spread over a half dozen tables. Not many updates or deletions (usually). My problem involves fsm allocation and the vacuum utility. Recently, I vacuumed and the output told me I had 47

[ADMIN] COPY and partitioning

Hi I understand v8.1 implements table partitioning. Very exciting! I have a big table (30 G) that is a real headache. I'd like to partition it. My plan is the following: (1) use pg_dump -t to dump the data; (2) create a partitioning schema with check constraints; and (3) repopulate usin

[ADMIN] pg_dump and truncate

Hi: While pg_dump is dumping my database, I find that when I try to truncate a table the query hangs. Is that the expected behavior? What if I try to drop a table? Will that hang as well? Thanks as always! ---(end of broadcast)--- TIP 1: if

[ADMIN] excluding a table from pg_dump

Hi: I don't think this is possible, but I want to make sure. Let's say I have a database that I want to dump in its entirety, all except for one particular table. Is there an option flag on pg_dump that accomplishes this? Thanks again! ---(end of broadcast)---

[ADMIN] query for view code

Hi: Can I query the database for the code for a particular view? Thanks for your help! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] display function code

Hi: I wrote a function for my database and 'loaded' it, but then misplaced the code. Is there a query I can issue to retrieve it? Thanks ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose

[ADMIN] vacuum message

Hi: I did a vacuum verbose on my database and at the end of the output I got the following: INFO: free space map: 85 relations, 18940 pages stored; 29584 total pages needed DETAIL: Allocated FSM size: 1000 relations + 2 pages = 186 kB shared memory. VACUUM Can somebody tell me wh