Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?

Do keep in mind that querying across databases generally garners really poor performance, and can bring your application to its knees with astonishing speed. From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] on behalf of Albe Laur

Re: [ADMIN] Upgrading from 9.1 to 9.2 in place, same machine

u can with slony. Just replicate from 9.1 as master to 9.2 as a slave. Once they are fully in sync, promote 9.2 to master. Note that you will have to restart postgres at least once to move the 9.2 port to the same as the 9.1 port when you switch. SO it won't be zero down time, but pretty d

Re: [ADMIN] Recreate primary key without dropping foreign keys?

On 04/17/2012 07:43 AM, Igor Neyman wrote: >> -Original Message- >> From: Chris Ernst [mailto:cer...@zvelo.com] >> Sent: Monday, April 16, 2012 10:55 PM >> To: pgsql-admin@postgresql.org >> Subject: Re: Recreate primary key without dropping foreign keys

Re: [ADMIN] Recreate primary key without dropping foreign keys?

foreign key as deferrable at creation. Is there any way to set an existing foreign key as deferrable? - Chris -- 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] Recreate primary key without dropping foreign keys?

On 04/16/2012 02:39 AM, Frank Lanitz wrote: > Am 16.04.2012 10:32, schrieb Chris Ernst: >> On 04/15/2012 10:57 PM, Frank Lanitz wrote: >>> On Sun, 15 Apr 2012 18:41:05 -0600 Chris Ernst >>> wrote: >>> >>>> Hi all, >>>> >>>>

Re: [ADMIN] Recreate primary key without dropping foreign keys?

On 04/15/2012 10:57 PM, Frank Lanitz wrote: > On Sun, 15 Apr 2012 18:41:05 -0600 Chris Ernst > wrote: > >> Hi all, >> >> In PostgreSQL 9.1.3, I have a few fairly large tables with >> bloated primary key indexes. I'm trying to replace them using >>

[ADMIN] Recreate primary key without dropping foreign keys?

't found a workable solution. Is there any way to swap in the new index for the primary key constraint without dropping all dependent foreign keys? Or am I pretty much stuck with dropping and recreating all of the foreign keys? Thanks in advance. Chris Ernst Data Operations Engineer Zvelo, Inc. h

[ADMIN] Question about multiple slaves and Master loss.

e to fail before server A could be recovered. Thanks, Chris

Re: [ADMIN] Question about GSSAPI

ent. Hope that helps. - Chris On 09/21/2011 08:05 PM, Patrick Garner wrote: > Are the pre-built binary packages built with support for GSSAPI > authentication? > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http:/

Re: [GENERAL] [ADMIN] Using Postgresql as application server

that either the software you are using is the problem or the architect is. However, it doesn't tell me that the approach of using the RDBMS as the entry point into an application server environment is necessarily a bad thing. Best Wishes, Chris Travers -- 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] [GENERAL] Using Postgresql as application server

thing and so there is a LOT of trial and error. Also, it is quite possible to do a heck of a lot in this area in SQL and PLPGSQL. Focus on writing unified, maintainable queries and semantically meaningful interfaces (argument names, function names, etc). Best Wishes, Chris Travers -- Sent vi

Re: [ADMIN] replication from Oracle to PostgreSQL?

On 08/11/2011 08:41 AM, CS DBA wrote: > Hi All; > > Anyone know of tools / options that will allow Oracle to PostgreSQL > replication? or at least a real time feed or dblink? > > > Thanks in advance... > I believe EnterpriseDB Advanced Server does it (http://www.enter

Re: [ADMIN] changing work_mem

SET work_mem='1GB'; (or whatever size makes sense) - Chris On 06/13/2011 10:29 AM, Dinesh Bhandary wrote: > Hi All - > > Is there a way to change work_mem for a session in postgres without > restarting a database? Please let me know. > > Thanks. > Dine

Re: [ADMIN] Scaling

if you want simple pooling. pgpool is is also a great pooler and a lot more (e.g. load balancing, horizontal scaling, etc), but is a bit more complex to set up. - Chris -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Autovacuums running on unused tables/databases

I am having some issues with forced autovacuum kicking on and vacuuming tables that should not need to be vacuum'd. Initially we believed this to just be high usage on these tables and dug into what could be causing xid's to increase so quickly. We were never able to find querys that were doing

Re: [ADMIN] Postgres on Windows

ammar.fall...@automata4.com ("Ammar Fallaha") writes: > Anyone knows of a group to support Postgres on Windows? > > Obviously your group main concern is Postgres on Linux/UNIX. > > Searching on the internet is not resolving anything SPECIDIC to > Postgres for Windows. It's quite possible that most

Re: [ADMIN] State of multi-master replication options

scott.marl...@gmail.com (Scott Marlowe) writes: > On Thu, Jan 20, 2011 at 9:53 AM, CS DBA wrote: >> Hi All; >> >> I suspect I know the answer to this... >> >> What's the current state of multi-master replication for PostgreSQL? Is >> Bucardo the only true master/master solution out there that migh

Re: [ADMIN] preventing transaction wraparound

mbro...@gmail.com (Mike Broers) writes: > Lately I have been paranoid about the possibility of transaction wrap > around failure due to a potential orphaned toast table.  I have yet to > prove that I have such an object in my database.. but I am running > Postgres 8.3 with auto_vacuum enabled and a

Re: [ADMIN] Best Linux filesystem for Postgres data store ?

nick.le...@rentrakmail.com ("Lello, Nick") writes: > What is considered the best filesystem to use for postgres data stores ? What is your metric for "best"? Several are plausible: - Fastest, for write workload (read performance doesn't usually vary much based on filesystem) - Fastest, for re

[ADMIN] Pre-Allocate tablespace on disk

is be done with PG at all? If not, is this planned for any time in the future? best regards, chris -- chris ruprecht database grunt and bit pusher extraordinaíre  -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [ADMIN] GUI ERD/ERM tools?

loupicci...@comcast.net (Lou Picciano) writes: > This question from our users keeps coming up... > > What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder > is helpful, but doesn't address the need. > > Can any of you recommend specific tools, preferences, etc? I have tend

Re: [ADMIN] 2 PGSQL instances in the same server

rbarr...@gmail.com (Ramiro Barreca) writes: > We need to have, for migration, either an instance of our actual PG 8.4.4 and > a > new one of PG 9.0 for testing. > Where can we found a paper for helping us? > Our platform is Centos 5.4 x86 64 bits The "complication" to this is that it is quite lik

Re: [ADMIN] Database level encryption

terminato...@gmail.com (Timothy Madden) writes: > Andreas 'ads' Scherbaum wrote: > >> If someone captures the machine the bad guy can install a network >> sniffer and steal the database passwords upon connect. > > I think protecting against a keylogger is a different issue than > database encrypti

[ADMIN] pg_dump dumping out some irrelevant grants

I'm finding that pg_dumps are dumping out, right near the end, the following sequence of grants that are causing our QA folk a little bit of concern: REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM chris; GRANT ALL ON SCHEMA public TO chris; GRANT ALL ON SCHEMA publ

Re: [ADMIN] Catching up Production from Warm Standby after maintenance - Please help

jenniferm...@hotmail.com (Jennifer Spencer) writes: >>> Am I wrong? >> >> Probably. My first concern is to make sure you aren't doing VACUUM >> FULL as part of your maintenance cycle. That option is meant for >> recovery from extreme bloat, and is sort of a "last resort". > Good - glad to be wron

Re: [ADMIN] Security question UNIX Sockets vs CIDR style access

kev...@consistentstate.com (Kevin Kempter) writes: > I'm looking for thoughts/feedback on the use of UNIX Sockets vs standard CIDR > style access (i,e, Ident, MD5, etc) to a Postgres Cluster. What are the > pros/cons, which is more secure and why, etc... There is no single answer, which is essent

Re: [ADMIN] How to run PostgreSQL?

j...@commandprompt.com ("Joshua D. Drake") writes: >> > * Why should I have to configure a custom init.d script so my >> > PostgreSQL will start? >> >> to gain control over the system issue. From my perspective pg has always >> been at the enterprise layer, > > This surprises me a bit. In my exp

Re: [ADMIN] Updating a very large table

rafael.domici...@gmail.com (Rafael Domiciano) writes: > Hello Kevin, Thnks for response, > Doing the alter table to add the new column was fast: ALTER TABLE table1 ADD > COLUMN new_column date; > The problem is that I have to do a update in this column, and the values are > going to be the a misc

Re: [ADMIN] password strength verification

rexma...@yahoo.com (Rex Mabry) writes: > If a company requires a password to be a combination of letters, > numbers and special characters. Oracle has a profile setting with a > password verify function that can be used to specify a function > that can do this.  Does postgres have a setting or 

[ADMIN] moving users/roles from one server to another?

I'm a newbie to PG administration (although I have experience with other DBs). I need to move a single database to a brand new server. I've set up the new server with initdb, set up pg_hba.conf and postgresql.conf, and I can use dump and restore to move the database to the new environment. What

Re: [ADMIN] change user passwd

[EMAIL PROTECTED] (Isabella Ghiurea) writes: > I'm using PG 8.3.4 , what's the method for remote users to change > their PG passwd . The method is to use the "ALTER USER" command. -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "acm

Re: [ADMIN] replication with table add/removes..

[EMAIL PROTECTED] (Martin Badie) writes: > Hi, I have a system that have constant table adds/removes are > present. I want to make a replication between master and slaves but > not sure which one is the best solution for that kind of a > situation. Since I am new to replication stuff on postgresql

Re: [ADMIN] replica of database

[EMAIL PROTECTED] (Brad Nicholson) writes: > On Thu, 2008-09-11 at 12:19 -0600, Scott Marlowe wrote: >> On Thu, Sep 11, 2008 at 8:30 AM, Chris Browne <[EMAIL PROTECTED]> wrote: >> > [EMAIL PROTECTED] ("Joshua D. Drake") writes: >> >> Aftab Alam wrote:

Re: [ADMIN] replica of database

[EMAIL PROTECTED] ("Joshua D. Drake") writes: > Aftab Alam wrote: >> Yes ,I want a replica of my db so that I can use it as failover >> >> >> >> Version 7.3 linux AS release 4 update 6 > > Version 7.3 is end of life and I don't know of *any* of the > replication technologies that will work with it.

[ADMIN] Upgrading with WALs

we turn off WAL archiving while rebuilding the database with the pg_dumpall output? Thanks again. Chris -- 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] Upgrade clients when (major) upgrading server?

Scott Marlowe wrote: On Thu, Jul 24, 2008 at 9:00 AM, Chris Bovitz <[EMAIL PROTECTED]> wrote: We have 8.1.3 on our operational and development database servers and will upgrade to 8.3.3 (development) and 8.2.9 (operations) soon. (We will not upgrade both systems' da

[ADMIN] Upgrade clients when (major) upgrading server?

s, other than the note in the upgrade/installation man pages, is there a set of instructions for upgrading the client-side software? If we don't have to upgrade now, when would we have to? Are there any things to watch for I should be aware of? Thanks. Chris -- Sent via pgsql-a

Re: [ADMIN] answer my question, please!!!

[EMAIL PROTECTED] ("ria ulfa") writes: > i want to copy table from file with command: >  COPY log FROM '/tmp/logfile.txt'; > but there is error: >  ERROR: could not open file "/tmp/logfile.txt" for reading: Permission > denied > what can i do for repair this error?? > thanks for the answer

Re: [ADMIN] Questions on pg_dump

We understand that. The question is why is an uncompressed Fc format so much larger than a straight dump? Is the so bad it takes almost 5% extra space? On Fri, Jul 18, 2008 at 2:36 PM, Scott Mead <[EMAIL PROTECTED]> wrote: > Chris, > > Sorry I'm not responding to the li

[ADMIN] Questions on pg_dump

token like that with the -Fc that can be used to verify a successful backup? Thanks, Chris

[ADMIN] More Autovacuum questions

above is a very heavily used and modifed table. Thanks for any comments, Chris

Re: [ADMIN] 8.3 Autovacuum Questions

On Mon, Jul 14, 2008 at 4:29 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Chris Hoover escribió: > > I just have a couple of quick questions about 8.3 and Autovacuum. > > > > 1. When autovacuum chooses to vacuum a table, the entire table is > vacuumed, > >

[ADMIN] 8.3 Autovacuum Questions

specific period of time (say during a known peak usage period). 3. If I have a PostgreSQL cluster with 10 databases, does autovacuum_max_workers=3 mean I have a possibility of 3 total workers or 30 workers (i.e. autovacuum_max_workers * number of db's)? Thanks, Chris

Re: [ADMIN] Clustering 2 EDBs On windows

[EMAIL PROTECTED] ("Sunitha S") writes: > Hi All, > We have setup edb-edb replication by configuring the master on one machine > while slave on another machine(both running on Windows OS and > postgres plus Advanced 8.3) for achieving the remote master/slave setup as > per the following document

[ADMIN] What is the difference in storage between a blank string and null?

hat Postgres is doing differently with the nulls. Would someone kindly enlighten me on this. (P.S. I am using a nullif(trim(column),'') in my partition and view rules to store the nulls, and coalesce(column,'') to give my application the data back without nulls.) Thanks, Chris P

Re: [ADMIN] Tuning

[EMAIL PROTECTED] (Carol Walter) writes: > I have some questions about tuning. The PostgreSQL documentation > says that you don't need to worry about index maintenance and tuning > with PostgreSQL. I'm used to systems that work a lot better if they > are periodically re-orged or re-indexed. Is i

[ADMIN] PG Con

mention? Thanks, Chris -- Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution!

Re: [ADMIN] drop database, vacuum full and disk space

rom > scratch (in the 'rm' sense) wouldn't be too easy (work place > particularities). > Try running a reindex (reindexdb -e -d ) and cluster all of the tables. These are blocking transactions, but should release all of the bloat in your db. The cluster has to be run on a

Re: [ADMIN] Where to find information on the new HOT tables?

look here link" pointing to http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/README.HOT?rev=1.2 That is the link Alvaro sent me in the first part of the thread. It was a very good read explaining how HOT works along with the caveats. Chris -- Come see how to SAVE money

[ADMIN] Help calculating load values

a grasp on how much traffic I am creating for each major dml statement we issue so that I can work with my sysadmin on some i/o issues. Thanks, Chris PG 8.1 RH 4 -- Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution!

Re: [ADMIN] Where to find information on the new HOT tables?

On Feb 5, 2008 2:53 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > Chris Hoover wrote: > > I have been searching through the 8.3 documentation trying to find > > information on the new HOT tables that 8.3 provides and can not seem to > find > > any. Can someon

[ADMIN] Where to find information on the new HOT tables?

current application when we upgrade in a few months. thanks, Chris -- Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution!

Re: [ADMIN] [GENERAL] Can we have 2 databases on same server

1) Can I please know, if we can run 2 databases on the same server with out any conflicts? You can as long as they are installed in separate locations. That is: db1: /usr/local/pgsql/7.4 db2: /usr/local/pgsql/8.1 The main reason is so your app doesn't pick up the wrong binary and use

Re: [ADMIN] 8.3 Logging Question

On Jan 24, 2008 5:38 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > > The .log file is to catch any non-csv-format data that comes down the > pipe. You can't turn it off. > >regards, tom lane What type of data would you expect this to be?

Re: [ADMIN] 8.3 Logging Question

ogs into a table so that I can do further mining on them, so I am testing the csvlog. I have also been wanting to try the syslog feature for the logs, so I am testing this also. Really nice to have the option to send the logs to multiple outlets. HTH. Chris

[ADMIN] 8.3 Logging Question

file that grows and a 0 byte .log file. Since I'm not logging to stderr, why is the .log file being created, and how do I turn that off? Thanks for your help, Chris Relevent config file portion: #-- # ERROR REP

[ADMIN] All numeric database names?

Just wanted to check, are there any problems/gotcha's to having a cluster of all numeric database names? We are thinking of switching our database naming system to use our customer number (a 6 digit integer) for the database name. Is a negative/bad thing? Thanks, Chris PG 8.1

Re: [ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

rld anyway, there is no real need to do that, except if there are major issues with PG 64-bit under OS X. So far, it's still up and running. best regards, chris -- chris ruprecht network grunt and bit pusher extraordinaíre On Jan 3, 2008, at 14:09, Shane Ambler wrote: Chris Ruprecht

Re: [ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

, to go and give the completely built libphp5.so module to somebody and say 'here, run it' regardless of what his hardware architecture supports. best regards, chris -- chris ruprecht network grunt and bit pusher extraordinaíre On Jan 3, 2008, at 00:41, Tom Lane wrote: Ch

[ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

ues[i], att[i]->attlen); I have checked this using 8.2.5 as well, with the same results (except that the errors are on different line numbers, but in the same file, using the same function and arguments). Any help is appreciated. best regards, chris -- chris ruprecht network grunt and

Re: [ADMIN] best practices for separating data and logs

[EMAIL PROTECTED] (Tom Lane) writes: > "Peter Koczan" <[EMAIL PROTECTED]> writes: >> I'm planning a lot of changes for migrating to PostgreSQL 8.3, among >> them being a better way of separating data and logs (transaction logs, >> that is). > >> Currently, the OS and log data are on one disk system

[ADMIN] Is there a limit to the number of partitions?

nsive to be feasible? Thanks for any comments. Chris

Re: [ADMIN] Dump database more than 1 flat file

[EMAIL PROTECTED] ("Phillip Smith") writes: >> If doesn't have another way, how can I put the >> "header" in the begin of file without open? >> With "cat >>" command I put in the end. > > After the split files are loaded on the new server file system: > cat splitfile*.txt > bigfile.txt >

Re: [ADMIN] Enhancement request

[EMAIL PROTECTED] ("Jonah H. Harris") writes: > On Nov 30, 2007 4:30 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> For what? > > Convenience. > >> AFAICS we are moving as fast as we can in the direction of auto vacuum >> and analyze. Adding more frammishes to the manual commands seems like >> gilding

Re: [ADMIN] Migrating from 32 to 64 bit

[EMAIL PROTECTED] ("Medi Montaseri") writes: > But theoretically speaking, 32 or 64-bit ness of the application (ie the > postmaster server) should not influence the data types offered by a > particular DB > version. That is the semantics of data types and cpu-arch (register width, > big endian,

[ADMIN] Does copy increment pg_stat_user_tables.seq_scan?

Subject pretty much says it all. When I do my nightly dumps with pg_dump, does that copy statement on each table cause the stats collector to increment the seq_scan column? thanks, Chris pg 8.1.3 ---(end of broadcast)--- TIP 2: Don't &#x

Re: [ADMIN] any way to make query use index?

, or reconsider the choice of column type. > > regards, tom lane > how would you create this index? create index rev_code_text_idx on rev_code_desc(rev_code::text) fails complaining "ERROR: syntax error at or near "::"&q

[ADMIN] any way to make query use index?

of query. Of course, in our application it is SELECT rev_desc FROM rev_code_desc WHERE rev_code = lpad(, 4, '0'). Thanks for any help, Chris PG 8.1.3 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your de

[ADMIN] Upgrading from 7.2.1 to 8.x

management to upgrade this database. Also, I know there are a ton of fixes/improvements from 7.2, but are there any major data losing bugs in this version that I can use as added pressure on management? Thanks, Chris

Re: [ADMIN] Installing PostgreSQL as Admin

[EMAIL PROTECTED] ("Nandakumar Tantry") writes: >     Does any-ne know how to install PostgreSQL with > Administrator account? If not how will I do it? Any documentation > available?:p> I believe there is documentation on this matter here: http://pginstaller.projects.postgresql.org/faq/

Re: [ADMIN] Moving database install to new SAN

ata in a "hot"mode. HTH, Chris

Re: [ADMIN] How to update from 8.1 to 8.2 ?

those following this thread. HTH, chris

Re: [ADMIN] How to import CSV file?

DBI to insert it into the PG. Which is basically an ETL > (Extract, Transform, Load). I know insert is slower, but the point was to > show a general way that will always for. > > Cheers > Medi Montaseri > > On 8/28/07, Chris Hoover <[EMAIL PROTECTED]> wrote: > > >

[ADMIN] How to import CSV file?

help, Chris

Re: [ADMIN] ROI on 7.2 to 8.2

[EMAIL PROTECTED] ("Medi Montaseri") writes: > I have finally convinced my manager to "consider" the idea of > migrating from 7.2 to 8.2. Obviously he needs an ROI (Return Of > Investment) analysis (in a technical sense). So, I am wondering if > anyone has worked on a similar project where you had

Re: [ADMIN] How to export query results

specific column. If I want to extract this: select x.name,x.create_date from x where x.id = new.id how do I get copy to do this (simple example, I know)? Thanks, Chris PG 8.1

[ADMIN] How to export query results

query. Thanks, Chris

[ADMIN] help with query

many rows. How can I get it to work for tables with multi-column primary keys as well as single column primary keys? Thanks, Chris selecta.relname as table_name, c.attname as column_name, w.typname as domain_name frompg_class a, pg_constraint b, pg_attribute c, pg_type w

Re: [ADMIN] Downloading PostgreSQL source code version 7.1 through CVS

[EMAIL PROTECTED] ("Kevin Grittner") writes: On Tue, Aug 14, 2007 at 6:29 AM, in message > <[EMAIL PROTECTED]>, > "Kuriakose, Cinu Cheriyamoozhiyil" <[EMAIL PROTECTED]> wrote: >> Can anyone please tell me how to download the PostgreSQL-7.1 source code >> through CVS, i use the following set

Re: [ADMIN] Easy way to change table schema?

On 8/10/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Chris Hoover wrote: > > I have accidentally created some tables in the wrong schema. Since my > > testers have begun to use them and put data in them, I

[ADMIN] Easy way to change table schema?

I have accidentally created some tables in the wrong schema. Since my testers have begun to use them and put data in them, I was hoping for an easy way to move the existing tables. Is there a way to move tables between schema's w/o having to drop and recreate? Thanks, Chris

Re: [ADMIN] Joining tables in two different databases?

On 8/8/07, Michael Goldner <[EMAIL PROTECTED]> wrote: > > Is it possible to access tables in two different databases, running on > the > same server, from within psql? > Take a look at dblink in the contrib area. I think it will give you what you are looking for. Chris

Re: [ADMIN] use replication on a database only on selected schemes?

[EMAIL PROTECTED] (Stefan Zweig) writes: > does anybody know whether it is possible to replicate only selected > schemes from a certain database using the slony-I replication > package, while other schemes from the same database do not get > replicated? In the Slony-I replication system, you choos

[ADMIN] Help with High value unicode characters

in our application. Obviously our developers will have to fix this in the application, but how do we fix it in our database. We are needed to clean up the existing data so our customers can view the data that has been imported up to this point. Thanks for any advice, Chris

Re: [ADMIN] Raw disk space used

[EMAIL PROTECTED] (Carol Walter) writes: > Is there a way to tell what the raw disk space used by a single > database is? I know that databases are fluid, but if there is way to > do even a snap shot view that is a "ball park" figure, I'd be happy. > My user keeps clammering for this figure. Sure

Re: [ADMIN] my postgres is dead. need help!

recovery mode, and is trying to clean itself up. Just let it alone and monitor the logs. If all goes well, it will tell you the recovery completed and it is online. Chris P.S. You are in desperate need of upgrading to a newer version of Postgres.

Re: [ADMIN] linux os

[EMAIL PROTECTED] (Mohd Ghalib Akhtar) writes: > how to download linux 7.3 image file(means os)  According to kernel.org, the latest version of Linux is 2.6.22.1. That's a long ways from some non-existent version 7.3... -- let name="cbbrowne" and tld="linuxfinances.info" in String.concat "@" [na

Re: [ADMIN] Help me find a suitable replication solution

[EMAIL PROTECTED] ("Yuan HOng") writes: > It seems Slony-II would be quite promising, but I can't wait that > long. What is the best choice for me now? Worth noting: Slony-II would never have been suitable, as it would have required that all the "master" servers be in the same data centre. I don'

Re: [ADMIN] database creation date

[EMAIL PROTECTED] ("Pradeep Chandru") writes: > > > Hi, >

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

[EMAIL PROTECTED] ("Shoaib Mir") writes: > Slony can handle this all. No it can't. It will not work with versions of PostgreSQL earlier than 7.3.3, because it requires namespace functionality that did not stabilize until that point. -- (reverse (concatenate 'string "moc.enworbbc" "@" "enworbbc")

[ADMIN] How to move a tablespace?

there a better way. Thanks, Chris

Re: [ADMIN] [pgsql-advocacy] [PERFORM] Postgres VS Oracle

[EMAIL PROTECTED] (Achilleas Mantzios) writes: >> I don't want to add gas to the flamewar, but I gotta ask. What is in >> the the 90 to 95% referred to in this email. > > short answer: all cases, possibly except when running a Bank or something > similar. No, it's not to do with what enterprise

Re: [ADMIN] [pgsql-advocacy] [PERFORM] Postgres VS Oracle

[EMAIL PROTECTED] (Carol Walter) writes: > I don't want to add gas to the flamewar, but I gotta ask. What is in > the the 90 to 95% referred to in this email. I'd say, look at the Oracle feature set for things that it has that PostgreSQL doesn't. Four that come to mind: - ORAC = multimaster rep

Re: [ADMIN] 8.2.4 Won't Build 8.1 Functional Indexes

it was an early index before I figured out how to split a timestamp. Anyway, is there a way to make the first index work? Otherwise we end up with a seq scan on our billing table which is very painful. Thanks, Chris On 6/6/07, Tom Lane <[EMAIL PROTECTED]> wrote: Alvaro Herrera <[

[ADMIN] How to tell how long server has been up?

Maybe I'm blind (wouldn't be the first time), but I can't see a way to find out how long postgres has been running. Is there a way to tell this from a query? I am working with some of the stat views and would like to correlate them to how long the server has been running. Thanks, Chris

[ADMIN] 8.2.4 Won't Build 8.1 Functional Indexes

'::text), '-mm-dd'::text)); Reject: ERROR: functions in index expression must be marked IMMUTABLE SQL state: 42P17 This is on 8.2.4 installed from the official RPMS. thanks, Chris RH AS 4 PG 8.2.4 from RPMS

[ADMIN] Help with database change

nullif and coalesce? Can I expect to see a noticeable impact on performance if I do this? Thanks, Chris

Re: [ADMIN] Deletes hurt

Just curious, what sort of field do they use to mark the rows? I'm assuming a timestamp since it would half to be part of the primary key, or am I way off? This has really gotten me thinking about how I might implement this in my database. Thanks, Chris On 5/31/07, Jim Nasby &l

Re: [ADMIN] Fwd: Out of Memory on Reindex

user processes (-u) 159744 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited This is on a 32bit dual HT Xeon system using the official rpms. Chris P.S. Sorry for the direct reply, forgot to hit reply all. On 5/31/07, Tom Lane <[EM

Re: [ADMIN] Fwd: Out of Memory on Reindex

maintenance_work_mem = 1048576 (I have 9GB ram on this server). Chris On 5/30/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Chris Hoover" <[EMAIL PROTECTED]> writes: > I am getting the following error when trying to run a reindex on one of my > databases. > reindex

  1   2   3   4   5   6   >