[ADMIN] unsubscribe

2006-01-19 Thread dove-young
unsubscribe HI,你 用 过 网 易 相 册 批 量 上 传 工 具 吗 ?想 传 多 少 就 传 多 少 ,还 是 免 费 的!

Re: [ADMIN] "Blueprints for High Availability"

2006-01-19 Thread Bradley Kieser
Bas, I am working on an integration technique that solves these problems and is already showing tremendous promise. It's in production use in a very high pressure environment but suffice to say it's an integration of what's out there (I am 100% Linux based so don't expect anything but Linux).

[ADMIN] "Blueprints for High Availability"

2006-01-19 Thread Brian A. Seklecki
Wiley Press, ISBN 0-471-43026-9, Even Marcus & Hal Stern Whatever you do, don't read this book when planning your enterprise-class PostgreSQL cluster using Slony1. The author(s) give a scathing opinion of network based asynchronous database replication. Especially for redundant configuration

Re: [ADMIN] WAL log archive frequency

2006-01-19 Thread Bruce Momjian
Tom Lane wrote: > Chris Jewell <[EMAIL PROTECTED]> writes: > > Further to my question on PITR, I have now implemented it :-) However, > > I was wondering about the frequency of archiving the WAL. Does > > postgresql wait until the current WAL file has reached 16MB before > > calling the archive_c

Re: [ADMIN] killing a query safely

2006-01-19 Thread Tom Lane
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: > many a times the backend are stubborn. A backend is currently > executing a Query , the query usually finishes quickly < 5 secs. > But this query is on for past many minutes. I want to debug why > it is hung if it is hung. Attach to the backend pro

Re: [ADMIN] Distributed database with postgres

2006-01-19 Thread Jim C. Nasby
On Thu, Jan 19, 2006 at 03:46:25PM +0100, Juan Miguel wrote: > Hello, > > First of all, sorry about my english. I'm searching a tool for > implementing a distributed DB in postgres. I've found "pgreplicator" > (http://pgreplicator.sourceforge.net/). I figure out that the last > revision of the

Re: [ADMIN] Question

2006-01-19 Thread Scott Marlowe
On Thu, 2006-01-19 at 09:59, Chris Van Reenen wrote: > Hi. > > > > I want to find out if postgresql can be used in place of MS SQL? > > But I want to find out if I can get SharePoint working on postgre with > out any limitations. > > I was given the task to see if there is any other DB that w

[ADMIN] Question

2006-01-19 Thread Chris Van Reenen
Hi.   I want to find out if postgresql can be used in place of MS SQL? But I want to find out if I can get SharePoint working on postgre with out any limitations. I was given the task to see if there is any other DB that we can run share point on. I don’t want to try for months and th

[ADMIN] killing a query safely

2006-01-19 Thread Rajesh Kumar Mallah
Hi, many a times the backend are stubborn. A backend is currently executing a Query , the query usually finishes quickly < 5 secs. But this query is on for past many minutes. I want to debug why it is hung if it is hung. I have also tried to kill this query using following methods: SQL> SEL

Re: [ADMIN] [GENERAL] Problem with restoring database from 7.3.1 to 8.0.1

2006-01-19 Thread Kai Hessing
Hi Tom, thanks for your answer. I did some testing now but still have the same problem. Tom Lane wrote: > Kai Hessing <[EMAIL PROTECTED]> writes: >> [DB-Problem] > > Hmm. This looks like a pg_dump bug, ie, issuing ALTER OWNER commands > for the wrong index name (or, perhaps, issuing them befor

[ADMIN] Need help in installing postgresql 8.1.2 on Windows

2006-01-19 Thread Sarvjot Kaur
Sir I am trying to install Globus Toolkit4 on Windows machine. Postgresql8.1.2 is required software for installing GT4. But i cant get installation steps from anywhere.. Please help me and do reply Thanks Sarvjot Yahoo! Photos Got holiday prints? See all the ways to get quality prints in y

[ADMIN] Trouble installing on XP home

2006-01-19 Thread Dave M
I'm trying to install postgresql on my laptop, windows XP home edition sp2. can't install as a service: I either have too much permission or not enough... Here are the steps I performed and the generated messages: 1)I ran the install program (postgresql-8.1) the data directory chosen is a folder

[ADMIN] Transferring DATA directory

2006-01-19 Thread Alfred
Hi, I'm trying to transfer large amounts of data between two PostgreSQL 8.1.2 database Windows XP platforms using the physical filesystem backup method. I used the same PostgreSQL installer on both machines and the same PostgreSQL configuration. I also used default options with PostGIS options

[ADMIN] Why psql.exe does not work?

2006-01-19 Thread Sean G
Hello, I have done a silent installation, the installation worked eventually, and I can use pgAdmin interface to connect to it. However I have problem using psql.exe to connect to the database. I need to create a database called delphie from command line. It should be a part of the installation I

Re: [ADMIN] WAL log archive frequency

2006-01-19 Thread Tom Lane
Chris Jewell <[EMAIL PROTECTED]> writes: > Further to my question on PITR, I have now implemented it :-) However, > I was wondering about the frequency of archiving the WAL. Does > postgresql wait until the current WAL file has reached 16MB before > calling the archive_command? Yes. The assumpt

[ADMIN] Distributed database with postgres

2006-01-19 Thread Juan Miguel
Hello, First of all, sorry about my english. I'm searching a tool for implementing a distributed DB in postgres. I've found "pgreplicator" (http://pgreplicator.sourceforge.net/). I figure out that the last revision of the project was in 2001, and I don't know if the project goes on. I have

[ADMIN] WAL log archive frequency

2006-01-19 Thread Chris Jewell
Hi, Further to my question on PITR, I have now implemented it :-) However, I was wondering about the frequency of archiving the WAL. Does postgresql wait until the current WAL file has reached 16MB before calling the archive_command? The reason why I ask is that last night, after doing the base

Re: [ADMIN] effects of cancelling a vacuum full

2006-01-19 Thread Gourish Singbal
  One Question out of curiosity .. How did u cancel the vacuum full ?. 1. killed the process id  .. eg using kill -9 2. canceled the vacuum full from command prompt eg using "ctrl C". 3. or did an immediate shutdown .   On 1/18/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: On Wed, 2006-01-18 at 12:1

Re: [ADMIN] Fw: lo_import problem

2006-01-19 Thread sandhya
ok...jeff thank you very much. I checked in pg_hba.conf and reloaded again and did now working fine. - Original Message - From: "Jeff Frost" <[EMAIL PROTECTED]> To: "sandhya" <[EMAIL PROTECTED]> Cc: "Postgres" Sent: Thursday, January 19, 2006 1:13 PM Subject: Re: [ADMIN] Fw: lo_import pro