Re: [ADMIN] large database: problems with pg_dump and pg_restore

hings when reloading. Just my thoughts, ~mark -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Jehan-Guillaume (ioguix) de Rorthais Sent: Tuesday, October 26, 2010 4:22 PM To: Martin Povolny Cc: pgsql-admin@postgresql.org S

[ADMIN] locales and encodings Oh MY!

TF8 -E UTF8 Thank you, Mark -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] locales and encodings Oh MY!

On Fri, Nov 12, 2010 at 12:45 AM, Gabriele Bartolini wrote: > Hi Mark, > > Il 12/11/10 03:31, mark ha scritto: >> >> I have listed what I think I will be doing with regards to initdb. if >> anyone >> sees problems with the following mixture during my dump ->  i

Re: [HACKERS] [ADMIN] locales and encodings Oh MY!

> "put a C-locale index on the column", but text_pattern_ops is the way to > do it today. > >                        regards, tom lane > Ok I hear you loud and clear.I am going to eat the overhead until I get to 9.0.1, currently on 8.3.X in some places. I will either

[ADMIN] FW: PG 9 OpenLDAP 2.4 dependency ? (in a jam)

with that LDAP instance. Thanks Mark -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] PG 9 OpenLDAP 2.4 dependency ? (in a jam)

that LDAP instance. Thanks Mark -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] how to tell if a replication server has stopped replicating

http://archives.postgresql.org/pgsql-hackers/2010-11/msg00252.php Those two posts should cover the basics. There are other ways some people use to do it, but this seems to be the generally accepted way. I think 9.1 has some stuff in the works that should make it far easier to monitor. -Ma

[ADMIN] timestamp in 7.2

t;date" I need to make querys with timestamp(date,time); But timestamp don't work even with sample from manual: klienti=# select timestamp(date '1998-02-24',time '23:07'); ERROR: parser: parse error at or near "date" Mark ---(end o

[ADMIN] oids

Hello, All! Is there other meanings of oids than unique row identifier? Can I make two identical tables in the same database (even with oids)? Something like this CREATE TABLE table2 AS (SELECT oid,* FROM table1); Or oids must be unique in whole database? Mark

[ADMIN] Upgrade

Hello, All! I'm planing to upgrade from 7.2.1 to 7.3.4. Will pg_dumpall and pg_restore be sufficient for propper data migration? Mark ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subs

[ADMIN] Installation failure Solaris2.6/Sparc

akefile to get it to work right. You can email me if you have other problems. -Mark > >Date: Wed, 3 Feb 1999 11:55:09 -0700 (MST) >From: "Marc Wrubleski (403)220-7598" <[EMAIL PROTECTED]> >Subject: Installation failure Solaris2.6/Sparc > >I know this

[ADMIN] Re: HELP

ocal/pgsql/lib, IIRC it's called LDPATH. Just append that dir to it... -Mark Mark Linvill Programmer Winstar Broadband Services On Thu, 4 Mar 1999, Daniel Herssein wrote: >Hi, >I cannot find a user newsgroup on pgsql, but I saw your name on a reply >for help... >I ho

[ADMIN] RE: [HELP] Install Problem 6.4.2 on Solaris 2.6

Are you using gnu flex? From your output it kinda looks like you're using the lex that comes with solaris. It won't work with Postgres. See the FAQ for the correct version of flex... -Mark >-- > &g

Re: [ADMIN] illegal page faults. . .

x27;text' data type is standard SQL, it seemed to work better for large fields and I had better luck using it with PostgreSQL's built-in string functions. I hope this helps... Mark. JT Kirkpatrick wrote: > i got no response on the interfaces list -- maybe someone here has > experi

[ADMIN] Re: vacum, locks, indicies and whatnot

Thanks for the code and ideas, Todd; I have kept a copy for my files. Mark -- Mark Dalphin email: [EMAIL PROTECTED] Mail Stop: 29-2-A phone: +1-805-447-4951 (work) One Amgen Center Drive +1-805-375-0680 (home) Thousand Oaks, CA 91

Re: Re: [ADMIN] How to set up users etc for Web access?

r is running as. Of course this assumes you have strict control over who is putting databases and php interfaces on your box, a way around that would be to run a separate webserver under a different uid for your database application. My $.02. -Mark >2.)You should run a 

Re: [ADMIN] RE: Security Question

his means editing the pg_hba.conf file every time a new database is created, but you can get around that with a couple of scripts and a trigger. Hope this helps, any queries about the theory of what I've said, just ask. Regards, Mark. -- Mark Jewiss Knowledge Matters Limited http://www.knowledge.com

RE: [ADMIN] RE: Security Question

e suggested are not ideal, but there are ways around it. To start with, you could simply restrict usernames to 8 characters. You can make up password files using other tools - the encrypt command in OpenBSD works for sure. Regards, Mark. -- Mark Jewiss Knowledge Matters Limited http://www.knowledge.com

[ADMIN] Re: Perl Script and Postgres DB running via Apache Web Server

periment with permissions by using two standard login accounts to see who can read what and when. For what it is worth, I often find with this kind of problem (CGI scripts that mis-behave especially when interacting with a database) that changing my httpd logging "up" from a level of &quo

[ADMIN] Feedback on auto-pruning approach

ss I track the daily growth of used_size and this tells me how many days of data I need to remove to stay within my limits.  The disk_size is not actively managed, but just represents the "high-water-mark" of the used_size. Questions: 1) I have found the 32 bytes overhead mentioned in a fe

Re: [ADMIN] Feedback on auto-pruning approach

as to what factors I should consider, I'd greatly appreciate it. Thanks, Mark

Re: [ADMIN] Feedback on auto-pruning approach

ion.  We've just decided we want to keep as much history as possible given space limitations. -Original Message- From: Jim C. Nasby [mailto:[EMAIL PROTECTED]] Sent: Tue 3/28/2006 10:19 AM To: Mark Liberman Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Feedback on auto-pruning appro

[ADMIN] Release plans for improvements to partitioning

ementing a solution based on the current partitioning, or waiting for the next generation of PG partitioning. Thanks, Mark

Re: [ADMIN] Release plans for improvements to partitioning

opefully, some/much of this is underway, but any insight would be appreciated because we need to determine whether we want to go down the path of implementing a solution based on the current partitioning, or waiting for the next generation of PG partitioning. Thanks, Mark

Re: [ADMIN] [JDBC] [SQL] Thoughts on a Isolation/Security problem.

nificantly less time than anticipated, and the decreased maintenance of only managing one database and the ease of building new global administrative and reporting tools definitely made the project worth while. -- Mark Lewis ---(end of broadcast)---

Re: [ADMIN] Tale partitioning

to delete the rows in pg_statistics for the master tables, as this thread indicates. http://archives.postgresql.org/pgsql-performance/2006-05/msg00024.php Once we employed the work-around things seem good. - Mark

Re: [ADMIN] Autovacuum Question

Title: RE: [ADMIN] Autovacuum Question >Does this mean that each run of autovacuum will vacuum/analyze all tables >that need work in the database that autovacuum is looking at? Yes, it will do all tables that satisfy the criteria. >Also, with over 200 databases, does this mean that a databa

[ADMIN] PGSQL Database Recovery in Portland Oregon Area needed ASAP

oceed.     markh Mark A. Holm President InfoArch, Inc.                  Cell:    (503) 750-9741 7456 SW Baseline, PMB#123. Office: (503) 943-3202 Hillsboro, OR 97123 Fax:   (503) 591-8584 http://www.infoarc

[ADMIN] DBA tasks

stable (sarge) and therefore 7.4. Moving to 8.1 soon (hopefully) I am a developer who has adopted the role of DBA. Thanks - Mark Matthews Object Craft Pty Ltd http://www.object-craft.com.au ---(end of broadcast

[ADMIN] Corrupted DB - Help

ations.     CPU 0.00s/0.00u sec elapsed 0.00 sec. <1054:2006-07-27 18:00:18 PDT>INFO:  "port_etr_state_offline": moved 213 row versions, truncated 16 to 2 pages <1054:2006-07-27 18:00:18 PDT>DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec. <1054:2006-07-27 18:00:18 PDT>LOG:  duration: 16.078 ms Any way to salvage this db? Thanks, Mark

Re: [ADMIN] CMS - portal server Question

There are products and techniques, however, to share information with other sources, such as relational databases, LDAP, filesystem files, etc." from http:// plone.org/about/plone Good luck ----- Mark Matthews General Manager Object Craft Pty L

[ADMIN] New to PostgreSQL

me as I basically Self-educate.   Thank you and I look forward to working with you through your mailing list.   Mark Steben AutoRevenue Lee, Massachusetts [EMAIL PROTECTED]  

[ADMIN] Question

figure out how to get the index name from there.  Any help would be appreciated. And, if this is not an appropriate forum to ask questions please tell me.   Thank you, Mark Steben   AutoRevenue

Re: [ADMIN] Question

Thank you, Jeff. That worked like a champ. My initial problem Had to do with not understanding the concept of OID datatypes. My next learning task is to read up on OID. Thanks again, Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07

[ADMIN] Question on partitioning

table that would reference ENTRY-DATE across partitions or will I need to build indexes and queries on each partition?   Thank you for your time, Mark Steben From: Mark Steben [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 3:18 PM To: 'pgsql-admin@postgresql.org

[ADMIN] Question on partitioning

also Does index scans on partitions 2, 3, and 4 which I did not expect since I limited the range in my WHERE clause to rows in partition 1. Do I need to load more data?  Any help would be appreciated.  I did set my CONSTRAINT_EXCLUSION to ON.   Thank  you, Mark Steben   From: Mark

Re: [ADMIN] Question on partitioning

Simon, you're right on the money.. the guys on the IRC chatroom suggested that I cast the partitioning column as SMALLINT as the optimizer assumed Integer and it worked. Thx for getting back to me Mark Steben AutoRevenue -Original Message- From: Simon Riggs [mailto:[EMAIL PROT

Re: [ADMIN] Problem with pg_dump / pg_restore

ckly grow beyond issuing any contentious values. --->>>>>>>>>>>>>>>>>>>>> #!/bin/bash # # script to include in crontab for 0 1 * * * root /postgresback # for backup and vacuum of the following two databases # # written by Mark C

Re: [ADMIN] Problem with pg_dump / pg_restore

Hi Armel, Why not do a structure only dump to plain text and see if you can use that as your start .sql ext file for 'psql -e .. etc'. Eliminates the necessity to have an active client side data dictionary. BTW, your english is fine. Regards markcarew@ magicwanddept.com.au ---

[ADMIN] Shutting down pgsql

the application that drives. I am running on debian linux testing, with pgsql 7.3.4. So I am wondering if it is possible and advisable to either kill the task, or shut down the database in order to do some work on it. Thanks, Mark Warner. ---(end of broadcast

[ADMIN] log file: showing disconnects as well as connects?

Here's a quickie script to watch a particular session: tail -f $LOG | awk ' /connection received: host='$1'/ { pid = $3 } $3 == pid { print }' Is there something in the log file which will indicate a disconnect as well? Many TIA, Mark ---

[ADMIN] hung postmaster when client machine dies?

the situation. Many TIA, Mark -- Mark Harrison Pixar Animation Studios Emeryville, CA ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] pg_dump privileges

_dump to run in addition to USAGE (for the language), EXECUTE (for the function) and SELECT (tables, views and sequences)? Thanks! Mark ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] pg-watchdog

Here is the final version of my script that will watch for disconnected client machines and kill their associated server side processes. If I'm doing anything really stupid I would appreciate hearing about it. If it's useful to anyone, feel free to pass it along. Thanks, Mark #!/bin/sh

Re: [ADMIN] talking to port 5432

On Fri, 6 Feb 2004, Ernst Roebbers wrote: Dear Sirs, I would like to communicate with the postgres backend using port 5432 from a small remote machine where only a socket is available - no application layer. Do You have any hints where I can find some information what kind of input the postmaste

[ADMIN] IDE and write cache

d use a large number of concurrent transactions to "guarantee" that when you pulled the plug, that it would be at an inopportune time? In other words, is an IDE drive still "more" susceptible to a power outage problem even under light load? Thanks! Mark ---

[ADMIN] 7.3.2 - 7.4.1 on RedHat 9.0

orphaning files if I do a straight compile from source (not getting the configured directories to be the same as the original installation). So the question is, do I uninstall the original RPM and do a compile from source? Do I go to a SRPM? Do I uninstall and then use a SRPM? TIA, Mark

[ADMIN] Schema comparisons

on system. Is there a utility that will compare the tables, functions, trigger, views, etc. between two systems and flag the schema elements that aren't in synch between the two? If not, and I need to write one, would such a system be of interest to anyone else? Thanks! Mark -

[ADMIN] Any Gentoo users interested in a slotted PostgreSQL ebuild?

hread at: http://bugs.gentoo.org/show_bug.cgi?id=42894 With a initial plan for relocation of files to support slotting. Comments, suggestions, corrections, or messages to say it's a silly idea (and why) would be very much appreciated before I attempt this next week. Cheers -- Mark G

[ADMIN] Multiple inserts without COPY

o I simply send a bunch of queries? Thanks! Mark ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] Multiple inserts without COPY

On Mar 3, 2004, at 10:22 PM, Tom Lane wrote: Mark Lubratt <[EMAIL PROTECTED]> writes: The deletes look something like delete from CL where CL_id = i where i could be a list of several hundred integers. Again, right now I iterate through the list. Consider delete from CL where CL_id in

Re: [ADMIN] Multiple inserts without COPY

On Mar 3, 2004, at 11:20 PM, Tom Lane wrote: Mark Lubratt <[EMAIL PROTECTED]> writes: Huh? You can use COPY FROM STDIN in most of our client libraries, certainly so with libpq. What are you using? Actually, I'm using REALbasic. Um. I have no idea what sort of support they have,

Re: [ADMIN] [HACKERS] Any Gentoo users interested in a slotted PostgreSQL

Mark Gibson wrote: Are there any Gentoo users here? Do you wish the PostgreSQL ebuild made use of SLOTS? I've submitted a slotted ebuild for testing at: http://bugs.gentoo.org/show_bug.cgi?id=42894 It's the first slotted ebuild i've attempted, so it may be total rubish! But I have

[ADMIN] Explain Analyze help

was 2 questions. Anyone? Bueller? Mark ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [ADMIN] syslog slowing the database?

hat points to the current output file. - gzips the rotated logfile If you have gnu tools installed, you can tail --retry --follow=name foo.current and it will automatically track the most recent log file. HTH, Mark -- Mark Harrison Pixar Animation Studios *** rotatelogs.c-orig 2004-03-10

Re: [ADMIN] [PERFORM] Benchmarking postgres on Solaris/Linux

Josh Berkus wrote: Mark, It might be worth considering Apple if you want a 64-bit chip that has a clock speed comparable to Intel's - the Xserv is similarly priced to Sun V210 (both dual cpu 1U's). Personally I'd stay *far* away from the XServs until Apple learns to b

Re: [ADMIN] [PERFORM] Benchmarking postgres on Solaris/Linux

lock speed comparable to Intel's - the Xserv is similarly priced to Sun V210 (both dual cpu 1U's). Are you free to choose any hardware? best wishes Mark Subbiah, Stalin wrote: (snipped) what is the preferred OS for postgres deployment if given an option betwe

[ADMIN] code editing

What is your recommendations for code editin in Postgresql? I'm a student at Regis university in Denver co. Thanks Mark Bross 13565 Detroit St. Thornton, Co. 80241 Email: [EMAIL PROTECTED] Ph: 303-252-9255 Fax: 303-252-9556 ---(end of broa

Re: [ADMIN] [PERFORM] Quad processor options - summary

systems. I am not saying "1M is wrong", but I am saying "1M may not be right" :-) regards Mark Bjoern Metzdorf wrote: 1. Get many drives and stripe them into a RAID0 with a stripe width of 1MB. I am not quite sure if this stripe width is to be controlled at the application

[ADMIN] no ftp

To whom it may concern, I really had no idea who to send my email to, but here it goes. I can't get to any of your ftp sites... NONE! I talked to my ISP, patched my modem and router, nada, zilch, nothing. Seems there's a router problem, except I can't for the life of me figure out why I can't get

[ADMIN] out of memory error

Hi, we are using Postgres with a J2EE application (JBoss) and get intermittent "out of memory" errors on the Postgres database. We are running on a fairly large Linux server (Dual 3GHz, 2GB Ram) with the following parameters: shared_buffers = 8192 sort_mem = 8192 effective_cache_size = 23488102

Re: [ADMIN] [HACKERS] Point in Time Recovery

n char *XLogArchiveDest; 5410c5410 < use_wal = XLOG_archive_dir[0] && !rel->rd_istemp; --- > use_wal = XLogArchiveDest[0] && !rel->rd_istemp; Now I have to see if I have broken it with this change :-) regards Mark Simon Riggs wrote: On Wed, 2004-07-14

Re: [ADMIN] [HACKERS] Point in Time Recovery

Here is one for the 'idiot proof' category: 1) initdb and set archive_command 2) shutdown 3) do a backup 4) startup and run some transactions 5) shutdown and remove PGDATA 6) restore backup 7) startup Obviously this does not work as the backup is performed with the database shutdown. This got me

Re: [ADMIN] [HACKERS] Point in Time Recovery

checkpoint record is at 0/A4D3E8 LOG: redo record is at 0/A4D3E8; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 496; next OID: 17229 LOG: archive recovery complete LOG: database system is ready regards Mark Tom Lane wrote: Huh? It works fine. The bit you may be missing is that

Re: [ADMIN] [HACKERS] Point in Time Recovery

Excellent - Just updated and it is all good! This change makes the whole "how do I do my backup" business nice and basic - which the right way IMHO. regards Mark Tom Lane wrote: Mark Kirkwood <[EMAIL PROTECTED]> writes: 2) Is is possible to make the recovery kick in even t

Re: [ADMIN] [HACKERS] Point in Time Recovery

I have tested the "cold" backup - and retested my previous scenarios using "hot" backup (just to be sure) . They all work AFAICS! cheers Mark Simon Riggs wrote: On Thu, 2004-07-22 at 21:19, Tom Lane wrote: Mark Kirkwood <[EMAIL PROTECTED]> writes: 2) Is is pos

Re: [ADMIN] Connecting Postgres using other network

Dumb question, but are you sure you want port 6432 instead of 5432?  Or was this a typo?   Cheers,   Mark Taber State of California Department of Finance Infrastructure & Architecture Unit 916.323.3104 x2945 From: Mohammad Tanvir Huda [mailto:[EMAIL PROTECTED]

[ADMIN] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in harmony! How?

0, and that the KrbSaveCredentials directive does this job instead. Is there any examples of this mod_perl script? Can the alleged mod_perl method be adapted to PHP? Has anyone got this to work? What are the alternatives to my goal stated above? Cheers -- Mark Gibson Web Developer & Database

Re: [ADMIN] [PHP] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in

Mark Gibson wrote: Hi, I've been trying to Kerberize our Apache and PostgreSQL servers for our company's web applications. Goal: To connect from a PHP web app to a PostgreSQL database using the users credentials, so all authorization is managed via privileges within the database. O

Re: [ADMIN] [PHP] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in

Mark Gibson wrote: Mark Gibson wrote: Hi, I've been trying to Kerberize our Apache and PostgreSQL servers for our company's web applications. [snip] I'VE DONE IT! THE HOLY GRAIL OF WEB/DB APPS! :) All it takes it this line your PHP script: putenv("KRB5CCNAME={$_SERVER[&#

[ADMIN] securing pg_catalog

pg_catalog but the user could still see data from the pg_catalog. Is there a way to prevent access to pg_catalog schema for a specified user? TIA, Mark Mark MillerTavve Software

[ADMIN] postmaster -i option...

ing the command 'ps -ax | grep postgres' Thanks, Mark Taber ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] What is this phantom user 128?

ver, while going out and checking some of the tables, this user shows up as a user with privileges on them (however, not on all tables).  How do I get rid of this user?  And how do I ensure that it doesn't get created again? Thanks in advance. Mark Taber State of California Depart

[ADMIN] PITR WAL backups

hat the file copied by the cron job also needs to be copied to your archive directory before running recovery. Is any of this correct or am I messing up the procedure entirely? Thanks, Mark Reidenbach ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] Cannot get postgres started on Fedora core 3

port, etc. Please point me in the right direction! Thanks! Mark ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [ADMIN] Cannot get postgres started on Fedora core 3

I shouldn't start postgres as root. If I just type "postgres" on the command line.... nothing. No warnings, no nothing. Mark > I've been trying to get postgres to start on my machine for a few days (on > and off) and have not been successful in understanding why it

Re: [ADMIN] Cannot get postgres started on Fedora core 3

verwritten on an update cycle. I guess I better get educated on selinux so I can turn it on and off at will without it driving the rest of my system insane. Is there a config file I can change to keep that from happening in the future? Thanks again! Mark > If I manually enter the command o

[ADMIN] REINDEX question

hy this is happening and what I can do in the short term? I know we are at a back-leveled version so perhaps the long-term answer is to upgrade. Thank you, Mark Steben Senior DBA - AutoRevenue Direct dial phone number: 413-327-3045 Please visit our new website at www.autorevenue

[ADMIN] Index on a COALESCE function

01-01')+timespan('45 days')), date(service_date+timespan('44 days', date(null),date(create_date),9,false) as send_date,last_send I can't seem to get this index to work on the function, just on the cid column. Any ideas would be appreciated Thank you, Mar

[ADMIN] row level locking

currently at version 7.4.5. Thank you for your time, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.

[ADMIN] update within trigger function

r function. Is there a command within plpgsql that can help me with this? This seems like an elementary question, but I am a very elementary user of Postgres functions. Thank you for your time, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480

[ADMIN]

could not send data to client: Broken pipe There is no pattern or record that we see causing this error. When we run this manually on the local machine we do not get this error. It is a Postgres function that is called. I would appreciate any insight into this matter. Thank you,

[ADMIN] Mass updates on a large table

is up? We simply cannot afford this table to be down for 3+ days during a production update. The production box is a 32meg RAM box. We are at Postgres 7.4.5. Thanks for your time and brainpower Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 48

[ADMIN] postgres 8.2.4 new installation - trying to get autovacuum to work

where? Log_min_duration_statement currently set to 2000 milliseconds. The updates show in the logs. The vacuum does not. Any help would be appreciated. Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 41

[ADMIN] BGWRITER in Postgres 8.2

I would like to test the new components of 8.2 as we upgrade from 7.4 next month. Is there any way to verify that the background writer is operational? Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA

[ADMIN] bgwriter update question

emain in memory until syncpoint in pre-8.0. Am I missing somethng? Thanks for your time Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[

Re: [ADMIN] bgwriter update question

Thanks Tom, every piece of new information adds to my education. I'm going to put to bed this effort of trying to verify BGWRITER, knowing that it works in 8.2 and move on. Regards, Mark Steben -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2

[ADMIN] Maintenance_work_mem question

ffers. I know this is Very large for 7.4.5 but may be more appropriate for 8.2.4. Any thoughts? Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporat

[ADMIN] where can I find doc for pg_buffercache?

n to be 8.2.5 per Scott M.) Thanks, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.com Vis

[ADMIN] Looking for an E/R tool for Postgres

Does anybody have suggestions as to what Entity_Relationship diagram tool Is out there that'll work for Postgres? Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office

[ADMIN] reconfiguring diskspace while upgrading to 8.2.5

massive growth over the Next 2 - 3 years. Any thoughts / comments would be appreciated. Also are there tools out there that monitor disk I/O and disk speed? Thanks for your time, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480

Re: [ADMIN] reconfiguring diskspace while upgrading to 8.2.5

All feedback would be appreciated. Thank you, Mark Steben _ From: Mark Steben [mailto:[EMAIL PROTECTED] Sent: Friday, December 28, 2007 10:09 AM To: 'pgsql-admin@postgresql.org' Cc: '[EMAIL PROTECTED]'; 'David Parks'; 'Craig Brothers' Sub

[ADMIN] no entry on pg_database for a live database

this? Any ideas would be appreciated Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.com Vis

Re: [ADMIN] no entry on pg_database for a live database

Thanks Tom - that did the trick We will be upgrading to 8.2 within the next couple weeks. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 22, 2008 12:20 PM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] no entry on pg_database for a

[ADMIN] production error

Hi folks, getting this error in production: unexpected chunk number 0 (expected 1) for toast value 34761 Any ideas on how to approach this? Two of the tables in the query have toast tables, one does not. Thanks, Mark Steben Senior Database Administrator @utoRevenueT A

[ADMIN] Error on CLUSTER command

eduled for implementation later this month or early March. Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.c

Re: [ADMIN] Error on CLUSTER command

The doc says to do an initdb and reload the data whenever you run pg_resetxlog. Do you concur with that even if we are only resetting the OID counter? -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, February 08, 2008 11:36 AM To: Mark Steben Cc: pgsql-admin

Re: [ADMIN] Error on CLUSTER command

] Sent: Friday, February 08, 2008 11:19 AM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Error on CLUSTER command "Mark Steben" <[EMAIL PROTECTED]> writes: > I am getting the following error when I attempt to CLUSTER on a table: > mavmail=# cluster mailer_

[ADMIN] Newly converted to 8.2.5 and getting this error

Any help would be appreciated. Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.com Visit ou

[ADMIN] auto_vacuum question

s vacuumed manually during the day do have this LAST_VACUUM column updated. The autovacuum does populate the LAST_AUTOVACUUM column For these tables. Any insights? Thanks Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee

  1   2   3   >