Re: [ADMIN] vacuumdb -v output

[EMAIL PROTECTED] ("Kevin Copley") writes: > Hi, > > I've just put a system into production in which some tables are updated > frequently - several times per > second. > > I'm doing a nightly vacuumdb -v, but am not sure if it's achieving anything. > Here's the output for one > table: > >   > > -

Re: [ADMIN] Another Data directory for second database - feasible?

[EMAIL PROTECTED] ("Tomeh, Husam") writes: > I have a postgres installation with one database on a server. I'd need > to create another database; however, I'm curious if there's a way to > create the second database in a different directory than the existing > one. Is that feasible and how? Or does

Re: [ADMIN] Database Encryption (now required by law in Italy)

pgman@candle.pha.pa.us (Bruce Momjian) writes: I owe you a patch on runtime.sgml for the summary I did on "Use of Encryption." I just sent it... -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "acm.org") http://www.ntlug.org/~cbbrowne/sap.html Rules of the Evil Overlord #78. "I will not tell my L

Re: [ADMIN] how do i kill user sessions?

[EMAIL PROTECTED] (Scott Marlowe) writes: > On Wed, 2005-05-11 at 15:08, Ing. Jhon Carrillo wrote: >> I have a problem with the users administration. When I want to erase >> (drop) some databases there's an error: ** database "name_db" is being >> accessed by other users.** I want to kill the us

Re: [ADMIN] [GENERAL] Storing database in WORM devices

[EMAIL PROTECTED] (Juan Miguel Paredes) writes: > I know it would be a hard approach but... perhaps ON DELETE and ON > UPDATE triggers would help? No, that's not even related to the real problem. The problem is that the ability to have transactions is deeply pervasive, and requires a writable sto

Re: [ADMIN] Sidetracking pg_autovacuum

[EMAIL PROTECTED] (Jeff Boes) writes: > (Environment: Pg 7.4.1 on Linux; yes, I know it's past time to > upgrade.) If you were running 7.2, I'd be pestering you ;-). We didn't get rid of our last 7.1 system until last December, and I think the backend is probably still running, albeit with nothin

Re: [ADMIN] possible os recommendations

[EMAIL PROTECTED] (David Bear) writes: > wanting to avoid religious warfare, I'm curious if there may be some > who would have recommendations for what operating system is 'best' to > run postgresql 8.x on.. I've used postgresql 7.x on FreeBSD. It was > already. But, I'm getting sucked into the li

Re: [ADMIN] Remote Access

Marcos <[EMAIL PROTECTED]> writes: > I have one server postgresql in my home computer, and now I have the > necessity of access it of my work, the question is. How I liberate > the access remote of postgresql with password? Is there some reason why Chapter 19 in the documentation, entitled "Client

Re: [ADMIN] Vacuum full takes forever

[EMAIL PROTECTED] (Pieter-Jan Savat) writes: > I'm facing the following problem. > > I have a postgres 8.0 DB with a table 'results' containing 6.000.000 > records. > This table has 16 indexes. Each one basically created to speed up > different queries. > > Because of some glitch in the system ther

Re: [ADMIN] Poolin' it

[EMAIL PROTECTED] (Kris Kiger) writes: > Howdy all. I'm doing some research on 'middleware' type connection > pooling, such as pgpool. I'm having some trouble finding other > options that are actively being maintained, whether it be by the > open source community or not. Can anyone point me to s

Re: [ADMIN] size of indexes and tables (more than 1GB)

[EMAIL PROTECTED] (jose fuenmayor) writes: > I read and have seen that when a table has more than 1GB it is divided > in several files with the names of inode,inode.1,inode.2,inode.3, etc. > > I have a table of 1.3 GB (9.618.118 rows,13 fields) it is divided in > that way as i see on /PGDATA/base

Re: [ADMIN] replication

[EMAIL PROTECTED] (Alain Rodriguez Arias) writes: > Please,anybody can tell me how to make replication of a PostGre DB What do you mean by "replication?" - If what you desire is to create a copy, then you can take a backup and restore it somewhere else. Read The Fine Manual if that fits

Re: [ADMIN] triggers

[EMAIL PROTECTED] (Kailash Vyas) writes: > hi > I have a query regarding triggers. > On INSERT, UPDATE, DELETE I want to fire a trigger to relect it to another > database on postgres sever. > how can I do this operation. > Thanks in advance, > Kailash Vyas If you wish the trigger to result in som

Re: [ADMIN] Disabling WAL for bulk data loads

[EMAIL PROTECTED] ("Kevin Keith") writes: > I am coming from an Oracle background - which in the case of bulk data > loads there were several options I had where I could disable writing > to the redo log to speed up the bulk data load (i.e. direct load, set > the user session in no archive logging,

Re: [ADMIN] postgresql cluster on SAN

[EMAIL PROTECTED] (Robert Ngo) writes: > Can i create create a cluster of postgresql server by sharing the > database file on a SAN? I am also looking into slony but slony replicate > data to each server and my database will potentially have terabytes of > data. I am thinking about a solution where

Re: [ADMIN] postgresql cluster on SAN

[EMAIL PROTECTED] (Robert Ngo) writes: > Robert Ngo wrote: > >> Chris Browne wrote: >> >>> [EMAIL PROTECTED] (Robert Ngo) writes: >>> >>> >>>> Can i create create a cluster of postgresql server by sharing the >>>> database

Re: [ADMIN] Performance question: Restore + INDEX

[EMAIL PROTECTED] (Aldor) writes: > I'm curious how other people do it: > > What is faster? > > 1. CREATE TABLE > 2. restore data > 3. CREATE INDEX > > or > > 1. CREATE TABLE > 2. CREATE INDEX > 3. restore data Creating the index AFTER loading the data is definitely faster. But by all means do yo

Re: [ADMIN] postgresql cluster on SAN

[EMAIL PROTECTED] (Robert Ngo) writes: > How about i have one SAN storage for the slony master node and > another SAN to be share by slave nodes that only do SELECT? That seems like a reasonable sort of idea... > Can Dell|EMC AX100i iscsi san with sata drive serve as storage for > postgresql serv

Re: [ADMIN] backup software for postgresql

[EMAIL PROTECTED] ("Robert Ngo") writes: > Which backup software out there work well with postgresql, I cannot > find one with backup agent for postgres.:p> You don't need one. You can simply schedule a job that runs "pg_dump" every so often (daily is common) to save data to a file. Most compete

Re: [ADMIN] Solving OID wrap-around in 7.4 DB?

[EMAIL PROTECTED] (Jeff Boes) writes: > On behalf of a previous employer who, due to major downsizing, is left > without an answer to this: > > What's the best way to treat impending OID wrap-around in a 7.4.8 > database? This DB has been online for about 18 months, and is expected > to hit the dre

Re: [ADMIN] Replication Solutions for PostgreSQL Master to Slave

[EMAIL PROTECTED] ("Joshua D. Drake") writes: >> You are looking for synchronous replication as opposed to async? >> >> >Currently i have Slony working, but am not satisfied with how it >> >accomplishes replication, or it's interface, and am curious what >> >others are using to accomplish replicat

Re: [ADMIN] excluding a table from pg_dump

[EMAIL PROTECTED] writes: > [EMAIL PROTECTED] wrote on 10/25/2005 02:31:51 AM: >> It's possible with pg_restore to exclude that table on /restore/, but >> that's not what you asked for.. >> >> On 25.10.2005 11:08, Gourish Singbal wrote: >> > pg_dump does not allow you to accomplish this task for su

Re: [ADMIN] Scanners connected to the database

[EMAIL PROTECTED] (Tharo Mohono) writes: > I have a small company and I am quite new in using > postgres, I have established that I can intall > postgres on a database server and connect to it from > terminals all over, and I just wanted to find out if I > can have plugins to the server as well, li

Re: [ADMIN] restore challenge

"codeWarrior" <[EMAIL PROTECTED]> writes: > it doesnt work that way this is postgreSQL -- a relational database. > you can't just copy the data directory like you can with mySQL or DBase, or > BTrieve or any of the "old-school" databases... if you need to backup and > restore data you ne

Re: [ADMIN] the best linux or bsd for postgresql

[EMAIL PROTECTED] ("Ing. Jhon Carrillo // Caracas, Venezuela") writes: > hi, > What is the best linux or bsd for postgresql 8.x? > i'm replacing a oracle system on suse enterprise 8 with clustering, > dataguard, .. > I need high and good performance for my system. > Is there any certified unix

Re: [ADMIN] Please guide me.

[EMAIL PROTECTED] ("Praveen Kumar (TUV)") writes: > I have install postgresql on Redhat AS 4.Now we want to migrate data > from oracle 8i to postgresql 8.1 and  want to create snapshots , > materialized view,dblink,taking online backup,logical backup and > establish replication  between three produ

Re: [ADMIN] How to find data directory

[EMAIL PROTECTED] (Ken Hill) writes: > That works nice. It shows my data directory in > '/var/lib/postgresql/7.4/main'. When I do an ls command, I get: > > $ sudo ls /var/lib/postgresql/7.4/main > basepg_clog pg_ident.conf pg_xlog postmaster.opts > root.crt > global pg_hba.conf

Re: [ADMIN] Backup - filesystem snapshots

[EMAIL PROTECTED] (Chris Jewell) writes: > I'm trying to implement a backup strategy for a research database in > order to prevent again users accidentally dropping their data. > > My preferred method would be to create regular snapshots of the data > directory, and then send this to the backup ser

Re: [ADMIN] [Slony1-general] "Blueprints for High Availability"

[EMAIL PROTECTED] ("Jim C. Nasby") writes: > > Well, I would generally have to agree on not using Slony 1 for HA. I > don't see how it could be considered acceptable to potentially lose > committed transactions when the master fails. Unless maybe my > understanding of Slony is flawed... Well, tha

Re: [ADMIN] database replication

[EMAIL PROTECTED] ("Ciprian Hodorogea") writes: > :o="urn:schemas-microsoft-com:office:office" > xmlns:w="urn:schemas-microsoft-com:office:word" > xmlns="http://www.w3.org/TR/REC-html40";> > > Hi All,:p> > > :p>  > >   Is there a stable solution for database replication with Postgres 8.1.x?:p> Sl

Re: [ADMIN] autovacuum

matthew@zeut.net ("Matthew T. O'Connor") writes: > Hope that helps. Real world feed-back is always welcome. While I'm at it, I should throw in an idea that I had a little while back about a "vacuum request manager." This is kind of orthogonal to everything else that has been happening with pg_au

Re: [ADMIN] Upgrading O/S requires Postgres re-build?

[EMAIL PROTECTED] ("Tomeh, Husam") writes: > Server running Postgres 7.4.5 with: > > Red Hat Enterprise Linux AS release 3.90 (Nahant) > Linux 2.6.9-1.648_ELsmp #1 SMP Tue Oct 26 12:24:18 EDT 2004 x86_64 > x86_64 x86_64 GNU/Linux > > I want to upgrade the O/S to: > > Red Hat Enterprise Linux

Re: [ADMIN] Is the database being VACUUMed?

[EMAIL PROTECTED] ("C. Bensend") writes: > Hey folks, > >I'm running 8.0.4 on OpenBSD, and I'm running into issues where > a large batch job will fire up and occasionally coincide with a > VACUUM. Which then makes this batch take an hour and a half, > rather than the 30 minutes it usually take

Re: [ADMIN] How to VACUUM this table? "998994633 estimated total rows"

[EMAIL PROTECTED] (Aldor) writes: > I'm just curious about a VACUUM plan of this table: > > 1st) When to do VAUUM? > 2nd) How often to do VACUUM? > 3rd) With which postgresql.conf paremeters to set up vacuum? > 4th) When to do a VACUUM FULL? > 5th) Can autovacuum of 8.1 be used in this case? > > I'

Re: [ADMIN] How to VACUUM this table? "998994633 estimated total rows"

[EMAIL PROTECTED] (Guido Barosio) writes: > quote: " If you are quite sure it has few if any dead tuples, it might be > something to try to avoid VACUUMing except as needed to evade the 2^31 > transaction limit..." > You may use the pg_stattuple software, included in the /contrib . This will > sho

Re: [ADMIN] Best filesystem

[EMAIL PROTECTED] (Arnau Rebassa Villalonga) writes: >Which is the best filesystem in linux for postgresql? nowadays I'm > using ext3, I don't know if other filesystems like XFS, > reiser... would be better from the performance point of view. As far as I can tell, ext3 is the best *supported*

Re: [ADMIN] 7.4 --> 8.0/8.1 upgrade

[EMAIL PROTECTED] (Jim Nasby) writes: > On Mar 28, 2006, at 7:55 PM, Scott Marlowe wrote: > >> On Tue, 2006-03-28 at 19:47, sh test wrote: >>> Hello admins! >>> >>> i need to collect as much information >>> >>> pro/cons on a possible upgrade from >>> >>> 7.4 ---> 8.0/8.1 version >>> >>> Aside from

Re: [ADMIN] New system recommendations

[EMAIL PROTECTED] (Scott Marlowe) writes: > Note that some folks have mentioned that Dell uses their own > firmware on these cards, and that firmware is supposedly slower than > the stock firmware those cards come with. Worse, the default behaviours apparently involve "works *like* RAID10" as oppo

Re: [ADMIN] Logging long queries: not all get logged

[EMAIL PROTECTED] writes: > Hi, > > I'm running PG 8.0.3. I'm trying to catch slow queries, so I have this in > postgresql.conf: > > # log queries that take more than 500 ms > log_min_duration_statement = 500 # in ms > > This does log _some_ queries that take > 500 ms to run. > However,

Re: [ADMIN] autovacuum for large periodic deletes

[EMAIL PROTECTED] ("Sriram Dandapani") writes: > Every night, a delete of about 50 million rows occurs on a table. Do > we need to explicitly vacuum the table or will autovacuum handle the > large deletes without affecting performance. I am trying to > determine whether or not I should completely r

Re: [ADMIN] autovacuum for large periodic deletes

[EMAIL PROTECTED] ("Sriram Dandapani") writes: > About 5-10 million rows stay after deletion. There are a few other > tables where the daily deletion totals about 3-6 million. It would appear there is something fairly not-sane about the process, then. You delete about 90% of the day's data from

Re: [ADMIN] Synchronize Backup to another remote database

[EMAIL PROTECTED] ("Jim C. Nasby") writes: > On Tue, May 16, 2006 at 09:35:57AM +0800, [EMAIL PROTECTED] wrote: >> Currently we want to upgrade postgresql to 8.1.3 but our current postgresql >> database (v7.2.2) is use in the production line so we can't stop the >> current database. >> So is there

Re: [ADMIN] Database port changing issue

[EMAIL PROTECTED] ("Guido Barosio") writes: > That's because your listen_addresses parameter points to localhost, > and that means that your will listen for connections through unix > sockets instead of via TCP/IP. > > In order to change this, you'll need to replace the string localhost > with the

Re: [ADMIN] Where are the temporary work / sort files please

[EMAIL PROTECTED] (adey) writes: > ...but I can't find pgsql_tmp in my v8.1.4 installation. > > Where can I find these temp files please? They get created on demand, and go away when that demand disappears. Run a big REINDEX and you'll see them pop into place... -- output = ("cbbrowne" "@" "ntlu

Re: [ADMIN] 8.1 Unique Index Issue/Bug???

[EMAIL PROTECTED] ("Joshua D. Drake") writes: > That is why IS NULL can be placed in a unique index because it isn't > actually there (in the theorectical sense). In effect, NULL is not actually a value. -- (reverse (concatenate 'string "gro.mca" "@" "enworbbc")) http://www.ntlug.org/~cbbrowne/sa

Re: [ADMIN] Changing a database owner on postgres 7.3

[EMAIL PROTECTED] (Devrim GUNDUZ) writes: > Hi, > > On Mon, 2006-07-17 at 12:33 +, Richard George wrote: >> I've run into trouble attempting to change the owner of a particular >> database. The offending line is - >> >> ALTER DATABASE test OWNER TO epg; > > There is no way to change ownership

Re: [ADMIN] Database Optimization and Peformance

[EMAIL PROTECTED] (Joe McClintock) writes: > My concern is this, doing a backup and restore does not seem an > appropriate way manage database fragmentation and performance. The > documentation I have read indicates that vacuum, analyze reindex are > the tools to use to de-fragment and optimize the

Re: [ADMIN] Security Concerns over User 'postgres'

[EMAIL PROTECTED] ("Lane Van Ingen") writes: > Looked at /etc/shadow, and (in fact) it doesn't have a password, so I was > wrong about that. > > Tried to use the login command to login directly log into postgres, but for > some reason could not do that on RHEL 4.0 either. So, like you said, I am >

Re: [ADMIN] best OS and HW for postgreSQL

[EMAIL PROTECTED] ("Joshua D. Drake") writes: > Scott Marlowe wrote: >> On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote: >>> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote: Hi everyone on the list. I want to know what is the reccommended OS to work with PostgreSQL , on specific wit

Re: [ADMIN] Recursive use

[EMAIL PROTECTED] (Alexander Burbello) writes: > Hi people, > > I need to know if Postgres do recursive search and how can I do! > I will explain my problem. > > > table COOPERATIVE > code_cooperative int > code_coo_father int > > I can have 3 level by business rules > > 1 - Father > - 2 - Ch

Re: [ADMIN] postgres in HA constellation

[EMAIL PROTECTED] (Brad Nicholson) writes: > On Wed, 2006-10-11 at 16:12 -0500, Jim C. Nasby wrote: >> On Wed, Oct 11, 2006 at 10:28:44AM -0400, Andrew Sullivan wrote: >> > On Thu, Oct 05, 2006 at 08:43:21PM -0500, Jim Nasby wrote: >> > > Isn't it entirely possible that if the master gets trashed i

Re: [ADMIN] License for PostgreSQL for commercial purpose

[EMAIL PROTECTED] ("Eric Yum") writes: > I am a developer of one commercial organization. We are going to > develop some applications with PostgreSQL 7.3.3. I learn from some > websites that it cost no charge for developing software with > PostgreSQL in commercial environment. However, I saw the Po

Re: [ADMIN] Raw devices vs. Filesystems

[EMAIL PROTECTED] ("Gregory S. Williamson") writes: > No point to beating a dead horse (other than the sheer joy of the > thing) since postgres does not have raw device support, but ... raw > devices, at least on solaris, are about 10 times as fast as cooked > file systems for Informix. This might

Re: [ADMIN] pg_hba.conf

[EMAIL PROTECTED] (mike g) writes: > I believe I found my problem. The Cisco VPN client I use encrypts data > at a 168 bit level. Postgres only supports up to 128 bit correct? That ought to be entirely irrelevant, as your VPN client would encrypt all data going across the network, encrypted or n

Re: [ADMIN] Pseudo-Off-topic-survey: Opinions about future ofPostgresql(MySQL)?

[EMAIL PROTECTED] ("Gregory S. Williamson") writes: > b) Informix is now part of IBM and is likely to be replaced by DB2 > over the next few years ... any bets on whether parts of Informix / > Illustra / etc. migrate into some variant of open source ? It's pretty clear that IBM bought out Informix

Re: [ADMIN] Pseudo-Off-topic-survey: Opinions about future of Postgresql(MySQL)?

[EMAIL PROTECTED] (Enrique Arizn) writes: >> But in the last ten years, I have never once heard mention of >> Ingres in a commercial context. I was aware of it via "University >> Ingres" and because of knowing a little history, both of which came >> from academia, not from the comme

Re: [ADMIN] HELP pleaseeee!!!

[EMAIL PROTECTED] ("andres barra") writes: > hi, somebody can help me??? > > I tried to create a new database but i can´t. > > psql: FATAL: Database "template1" does not exist in the system catalog. > createdb: database creation failed > > I tried to make initdb in another directory and it shows m

Re: [ADMIN] vacuum pg_attribute causes high load

[EMAIL PROTECTED] (kris pal) writes: > The server is running Postgres 7.4.1 on Linux. > > I tried to do a "vacuum pg_attribute" but its taking a while (I guess because of the > size- abt 2GB) and > the load on the server is going very high. Because of this the database server is > not responding.

Re: [ADMIN] Replication Options.

[EMAIL PROTECTED] (Pallav Kalva) writes: > I need to implement the following the replication scenario in > postgres database. Here are the details of what we are looking to > implement. > > Lets say I have 2 nodes Node1(US) and Node2(Canada), > > Node1: tableA , tableB > Node2: tableB , tableA

Re: [ADMIN] Migration from 7.1.3. to 7.4.7.

[EMAIL PROTECTED] (Scott Marlowe) writes: > On Wed, 2005-03-16 at 06:07, Dr. Roger Wießner wrote: >> Can anyone tell me how to successfully migrate from 7.1.3. to 7.4.7.? I get >> lots of errors... > > Try to have both installed at once (separate dirs, or separate machines) > and dump the 7.1.3 db

Re: [ADMIN] Many persistant client connections

[EMAIL PROTECTED] writes: > i would like to know if there is something like the Oracle "shared > server" possible with PostgreSQL. I have searched the archives but > have not found any real discussion regarding this. > > We have two CTI applications opening 2-3 persistant connections to > the addre

Re: [ADMIN] multiple servers updating from/to one

[EMAIL PROTECTED] (Marco Carvalho) writes: > Hi, all > > I need to do this scenario: > > Web Application Web Application Web Application >| | > | > pgsql server 1 pgsql server 2

Re: [ADMIN] Slony sync times

Zoomby Woof <[EMAIL PROTECTED]> writes: > I'm using slony1 version 1.2.1 and I'm trying to figure out what the > actual default of the 'sync_interval' parameter is. The manual says > 100 ms in one place, and 10 seconds on another...some other places on > the net says 60 seconds, I have even seen 2

Re: [ADMIN] slony with diff PostgreSQL versions

[EMAIL PROTECTED] ("Ezequiel Luis Pellettieri") writes: > Hi guys, I know I'm out of topic, but have you ever tried using > Slony with PostgreSQL 8.2x as master and PostgreSQL 7.4.x as slave? I've done it with 7.4.x as master, and 8.1.x as slave, the point of the exercise being that I wanted to up

Re: [ADMIN] Fwd: File systems linux !!!

[EMAIL PROTECTED] ("jose fuenmayor") writes: > Hi all, i need to install a database in postgres with high reading > rates, which is the best file system to do that , I am working on > linux. thanks in advance For read rates, it should be fairly irrelevant what filesystem you use. Access tim

Re: [ADMIN] Size of logfiles

[EMAIL PROTECTED] (Peter Elmers) writes: > I have searched the web and am sorry to say that i found nothing > about the default behavior of the log files of postgres. > > Can anyone tell me when postgres will delete the logfiles or what > postgres automatically do with them? Can you be a bit more

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] [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] 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")

Re: [ADMIN] database creation date

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

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] 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] 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] 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

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] 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] 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] 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,

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] 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] 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

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

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

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.

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] 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] 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] 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 

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] 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] 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] 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

[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 public TO

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

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] 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] 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

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] 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] 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

  1   2   >