Re: [GENERAL] Database cluster?

> > > I am considering splitting the database into tables residing on separate > > > machines, and connect them on one master node. > > > > > > The question I have is: > > > > > > 1) How can I do this using PostgreSQL? > > > > You can't. > >I'll jump in with a bit more info. Splitting tables

Re: [GENERAL] How do I install pl/perl

At 10:02 30/11/00 +0100, Marcin Bajer wrote: >Steve Heaven wrote: >> >> At 13:06 29/11/00 -0500, Robert B. Easter wrote: >> >When you compiled PostgreSQL, you have to give ./configure --with-perl so it >> >will make the .so file its looking for. See ./configure --help next time. >> > >> >> We i

[GENERAL] backup and store oids

Hi all, I'm using postgresql-7.0.2 on Linux RedHat 6.2 system. I need help to some question: 1. I have problem insert oid object in a table, not always, sometimes. I have the exception FastPath call returned FATAL 1: my bits moved right off Recreate index pg_attrib

Re: [GENERAL] Can PostGreSQL handle 100 user database?

Note that this is a Linux limitation ... and even then, I'm not quite sure how accurate that is anymore ... the *BSDs have supported >2gb file systems for ages now, and, since IBM supports Linux, I'd be shocked if there was a 2GB limit on memory, considering alot of IBMs servers support up to 4 o

Re: [GENERAL] Can PostGreSQL handle 100 user database?

> "LO" == Lamar Owen <[EMAIL PROTECTED]> writes: LO> The 2GB size limits of ia32 come in to play due to byte addressing LO> (versus word addressing) in ia32 plus the use of signed single register LO> two's-complement integers. LO> But, as always, I reserve the right to be wrong. You are wro

Re: [GENERAL] Can PostGreSQL handle 100 user database - more info

Replies inline. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com - Original Message - From: <[EMAIL PROTECTED]> To: "Adam Lang" <[EMAIL PROTECTED]> Sent: Thursday, November 30, 2000 12:40 PM Subject: Re: [GENERAL] Can PostGreSQL handle 100 user

Re: [GENERAL] Can PostGreSQL handle 100 user database?

Vivek Khera wrote: > LO> The 2GB size limits of ia32 come in to play due to byte addressing > LO> (versus word addressing) in ia32 plus the use of signed single register > LO> two's-complement integers. > LO> But, as always, I reserve the right to be wrong. > You are wrong. The file size limi

Re: [GENERAL] Table & Column descriptions

\d+ should show you the table schema with comments. If you're looking for the actual data, it's in pg_description. The objoid field matches the oid field in pg_attribute (which is the "fields" table for pgsql). On 30 Nov 2000, at 11:17, Dale Anderson wrote: >I am able to add table and col

RE: [GENERAL] Unanswered questions about Postgre

> > That is what transactions are for. If any errors occur, then the > > transacction is aborted. You are supposed to use > > transactions when you want either everything to occur > > (the whole transaction), or nothing, if an error occurs. > > Yes. There are certainly times when a transa

Re: [GENERAL] Can PostGreSQL handle 100 user database?

On Thu, Nov 30, 2000 at 01:48:43PM -0400, The Hermit Hacker wrote: > Note that this is a Linux limitation ... and even then, I'm not quite sure > how accurate that is anymore ... the *BSDs have supported >2gb file > systems for ages now, and, since IBM supports Linux, I'd be shocked if > there was

Re: [GENERAL] Can PostGreSQL handle 100 user database?

On Thursday 30 November 2000 14:48, The Hermit Hacker wrote: > Note that this is a Linux limitation ... and even then, I'm not quite sure > how accurate that is anymore ... the *BSDs have supported >2gb file > systems for ages now, and, since IBM supports Linux, I'd be shocked if > there was a 2GB

Re: [GENERAL] Can PostGreSQL handle 100 user database?

On Thu, 30 Nov 2000, The Hermit Hacker wrote: > Note that this is a Linux limitation ... and even then, I'm not quite sure > how accurate that is anymore ... the *BSDs have supported >2gb file > systems for ages now, and, since IBM supports Linux, I'd be shocked if > there was a 2GB limit on memo

Re: [GENERAL] Can PostGreSQL handle 100 user database?

Here is a link that explains memory. It is from a windows2000 magazine, but it isn't very NT specific. It speaks in genaralities. I thought it was a rather good atrticle. http://www.win2000mag.com/Articles/Index.cfm?ArticleID=7290 I don't think you need to be a subscriber to read it. Adam La

Re: [GENERAL] Database cluster?

I actually analyzed it once. I came to the conclusion that to do it right it would be easier to make an almost entirely new db but use the same external interfaces as PostgreSQL. To do a kludge of it, one might just implement a tier that sits between the user and a bunch of standard PostgreSQL b

Re: [GENERAL] Help with Database Recovery

"Hancock, David (DHANCOCK)" <[EMAIL PROTECTED]> writes: > Sorry I didn't give more detail. OS is Linux 2.2 kernel, PostgreSQL is > 6.5.3. The problem is that I copied the .../base/* directories elsewhere in > preparation for making base a symlink to a different filesystem with more > space. I t

Re: [GENERAL] Can PostGreSQL handle 100 user database - more info

[EMAIL PROTECTED] wrote: > > I am not sure what an ole db provider is? This must be another method of > talking to the server from a client application. What advantages does it have? If you intend to use ADO you need an OLE-DB provider. > I have the open source ODBC client (and I know a Java

RE: [GENERAL] Can PostGreSQL handle 100 user database?

Hi, 2Gb file *systems* have been supported forever and a day on Linux. ext2 supports this without batting an eyelid. 2Gb *files* have not been supported very well or very long on 32-bit systems. Essentially you need a recent 2.4.0-test kernel version (test7 and up) or a patched 2.2.x kernel (more

Re: [GENERAL] Unanswered questions about Postgre

On 30 Nov 2000, at 11:58, Joe Kislo wrote: > If you don't believe me, here's two fully SQL-92 > compliant databases, Oracle and interbase, which do not exhibit this > behavior: Ummm... havings lots of experience w/it, I can say many things about Oracle, but "fully SQL-92 compliant" sure isn't

RE: [GENERAL] Help with Database Recovery

Tom and others: Thanks for the guidance. We rebuilt and restored, and will just live with an earlier version of the data, sadder but wiser. It was good to (a) learn about pg_log and (b) realize that pg_dump and pg_dumpall are our good friends and we should use them. Today I also learned that s

Re: [GENERAL] Can PostGreSQL handle 100 user database - more info

But there is an OLE DB provider for ODBC, so you can use ADO with an ODBC; just not as nice. As for the multiple connections thing, I do not know anything about that. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com - Original Message - From:

Re: [GENERAL] Database cluster?

> Somebody mentioned the fact that postgres uses IPC for communicating > between processes. I think there are tools for clustering (I am not sure if > Mosix supports transparently allowing IPC across nodes) which can work > around that. one of those tool is distributed ipc

Re: [GENERAL] Can PostGreSQL handle 100 user database?

Marc SCHAEFER <[EMAIL PROTECTED]> writes: > On Thu, 30 Nov 2000, The Hermit Hacker wrote: > > > Note that this is a Linux limitation ... and even then, I'm not quite sure > > how accurate that is anymore ... the *BSDs have supported >2gb file > > systems for ages now, and, since IBM supports Lin

Re: [GENERAL] Database cluster?

On Thu, 30 Nov 2000, Doug Semig wrote: > I actually analyzed it once. I came to the conclusion that to do it right > it would be easier to make an almost entirely new db but use the same > external interfaces as PostgreSQL. To do a kludge of it, one might just > implement a tier that sits betwe

Re: [GENERAL] Can PostGreSQL handle 100 user database?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 30 Nov 2000, The Hermit Hacker wrote: > > Note that this is a Linux limitation ... and even then, I'm not quite sure > how accurate that is anymore ... the *BSDs have supported >2gb file > systems for ages now, and, since IBM supports Linux,

Re: [GENERAL] Table & Column descriptions

That is exactly what I was looking for. Thanks a lot. Dale. >>> "Joel Burton" <[EMAIL PROTECTED]> 11/30/00 01:29PM >>> \d+ should show you the table schema with comments. If you're looking for the actual data, it's in pg_description. The objoid field matches the oid field in pg_attribute (whi

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

At 09:44 AM 11/21/00 -0700, Tim Uckun wrote: >What about the php module? Does it take advantage of API? I don't know. If not, though, there wouldn't be much point in using AOLserver, since the simple and efficient database API is the main attraction. So I think there's a pretty good chance it

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

Tom Lane wrote: > Michael Ansley <[EMAIL PROTECTED]> writes: > > Remember also that the GiST library has been integrated into PG, (my brother > > is doing some thesis workon that at the moment), > > Yeah? Does it still work? You bet. One would otherwise be hearing from me. I depend on it quite

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

At 07:50 PM 11/30/00 -0600, GH wrote: >On Thu, Nov 23, 2000 at 07:58:29AM -0800, some SMTP stream spewed forth: >> At 09:44 AM 11/21/00 -0700, Tim Uckun wrote: >> >> >What about the php module? Does it take advantage of API? >> >> I don't know. If not, though, there wouldn't be much point in u

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

Franck Martin wrote: > > It seems that your code is exactly what I want. > > I have already created geographical objects which contains MBR(Minimum > Bounding Rectangle) in their structure, so it is a question of rewriting > your code to change the access to the cube structure to the MBR structu