Re: [ADMIN] server process (PID xxx) was terminated by signal 7

Στις Τρίτη 23 Ιανουάριος 2007 16:25, γράψατε: Achilleas Mantzios [EMAIL PROTECTED] writes: Since you have not told us what the platform is, there is no way to guess what signal 7 means. Its a Bus error (SIGBUS). Those remote servers run on linux. Hm, pretty indeterminate then --- could

Re: [ADMIN] Install XML on Postgres 8.1

Do we have XML docs indexing mechanism in the todo's for 8.3? as this is one of the problem I faced while moving the Oracle like XML functionality to PostgreSQL using xml2 contrib. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/24/07, Peter Eisentraut [EMAIL PROTECTED]

Re: [ADMIN] Install XML on Postgres 8.1

Shoaib Mir wrote: Do we have XML docs indexing mechanism in the todo's for 8.3? as this is one of the problem I faced while moving the Oracle like XML functionality to PostgreSQL using xml2 contrib. Indexing of data types is done in terms of operator classes (or maybe operator families in

Re: [ADMIN] Install XML on Postgres 8.1

The following will explain in detail how Oracle handles the XML data and also the indexing and searching mechanism for it: http://www.oracle.com/technology/oramag/oracle/04-sep/o54xml.html - Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/24/07, Peter Eisentraut [EMAIL

[ADMIN] Postgresql Upgrade 7.4 to 8.2

Hi, I am soon going to be testing postgresql upgrades from our ancient 7.4 version to the latest 8.2. Part of the reason (apart from the obvious) is that I want to implement WAL logging for backup and recovery. Some general questions I have are: 1. How is the backup and recovery using WAL

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

Any insights on upgrading will also help. Thank you, Radhika Hello! About upgrading you should read these links: http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html and http://www.postgresql.org/docs/8.2/interactive/migration.html Greetings, Matthias

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

Radhika Sambamurti написа: [...] Some general questions I have are: 1. How is the backup and recovery using WAL logging in 8.2 Currently we use Slony for replication, but have no PITR / backup in place, which makes me very nervous. [...] Also these:

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

Radhika Sambamurti wrote: 1. How is the backup and recovery using WAL logging in 8.2 It's great! -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

Peter Eisentraut wrote: Radhika Sambamurti wrote: 1. How is the backup and recovery using WAL logging in 8.2 It's great! Less filling! Seriously though, the PITR recovery mechanism is quite mature and usable. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command

[ADMIN] cluster or database?

Is there a drawback to have different clusters on the same system/diskspace? I have different applications I want to support initially on the same server/disk array. I was thinking it would be better/easier to have seperate clusters per app for ease of migration and security. Is it highly

[ADMIN] log entries in 8.2.1

I get about a gazillion of these series of entries in log_filename. What will I need to trim/insert in postgresql.conf to prevent these: jira,18397,jira,2007-01-24 04:59:03.705 EST,45b68790.47dd,BEGIN LOG: duration: 0.012 ms jira,18397,jira,2007-01-24 04:59:03.705 EST,45b68790.47dd,,PARSE

Re: [ADMIN] Print command equivalent in postgresql

On Tue, Jan 23, 2007 at 10:47:13 -0600, Negandhi, Nishith [EMAIL PROTECTED] wrote: Hi, In SQL Server there is a PRINT command that returns a user-defined message to the client. What is the equivalent of this on postgresql .?? Can you explain more about what you are looking for? If you

[ADMIN] pg_restore speed

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

[ADMIN] Can I copy data file and use it with other version of Postgresql

We are facing a probelm and its very urgent to sort it out. Please Help. The database server unexpectedly shutdown down due to power failure. On reboot, Postgresql server fails to start giving following Error:

[ADMIN] an atypical pg_restore?

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

[ADMIN] Logging just SQL commands in an SQL script format

I want to log all SQL commands as an executable script file for use in performance testing. Currently there is a lot of information in the log that is generated that would not be executable. Below is an example of what I would want to see; which is just the SQL. Example of log output:

[ADMIN] kerberos 5: wrong principal

I am having some trouble transitioning from a pam_krb5 setup to native Kerberos 5. What is the meaning of the following error: 2007-01-24 14:42:35 [3780] LOG: connection received: host=216.229.91.242 port=4744 2007-01-24 14:42:35 [3780] LOG: Kerberos recvauth returned error -1765328240

Re: [ADMIN] pg_restore speed

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

Re: [ADMIN] pg_restore speed

Joshua D. Drake [EMAIL PROTECTED] writes: Colton A Smith wrote: I have a 90G postgis-enabled postgresql database that I'm upgrading from 8.1.5 to 8.2.1. I initiated pg_restore nearly six days ago and it's still churning away, surely but slowly. Is this amount of time normal? Or have I