Στις Τρίτη 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 t
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]> wrot
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 8
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 PROTECTE
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 logging
>
> 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
--
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:
http://www.postgresql.org/docs/8.2/stat
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
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: Comman
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 super
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 LOG
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
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
--
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:
---
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 ta
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:
Select
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
postgre
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 day
"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 norma
19 matches
Mail list logo