Re: [GENERAL] PostGreSql database features questions

2003-09-13 Thread Richard Huxton
On Friday 12 September 2003 18:38, Ish Ahluwalia wrote: > Hi: > > I'm very new to PostGreSql database and actually looking to evaluate for > one of our project needs. Below please find some questions. I'm hoping > if I can get some insight into these questions. > > Thanks. > > Ish... > > 1) Does

Re: [GENERAL] pgSql Memory footprint

2003-09-13 Thread Richard Huxton
On Friday 12 September 2003 20:43, Ish Ahluwalia wrote: > Hi: > > Can anyone provide a rough guesstimate on how much memory does fully > conigured, with all the services turned on pgSql database require? > > I'm trying to make an estimate on how much memory would be required in > Flash and RAM to r

Re: need for in-place upgrades (was Re: [GENERAL] State of Beta 2)

2003-09-13 Thread Doug McNaught
Ron Johnson <[EMAIL PROTECTED]> writes: > And I strongly dispute the notion that it would only take 3 hours > to dump/restore a TB of data. This seems to point to a downside > of MVCC: this inability to to "page-level" database backups, which > allow for "rapid" restores, since all of the index s

[GENERAL] New DBTools Manager 2.2.0

2003-09-13 Thread Crercio O. Silva
We are pleased to announce the new release 2.2.0 of the DBManager Professional. It is a major bug fix bringing stability and performance to the application. Also it adds support to SQLite databases and Xbase Tables which you can manage using the same way you do for MySQL and PostgreSQL. In next ver

Re: need for in-place upgrades (was Re: [GENERAL] State of Beta 2)

2003-09-13 Thread Ron Johnson
On Sat, 2003-09-13 at 10:10, Marc G. Fournier wrote: > On Fri, 12 Sep 2003, Ron Johnson wrote: > > > On Fri, 2003-09-12 at 17:48, Joshua D. Drake wrote: > > > Hello, > > > > > > The initdb is not always a bad thing. In reality the idea of just > > > being able to "upgrade" is not a good thing. J

Re: [GENERAL] [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

2003-09-13 Thread 3rd.
hi Marc, for whatever reason i think your board is very confusing and hard to find information. i was hoping you could help me by answering a few questions about postgresql. why don't you people have a regular PHPBBs? they are so easy to use and understand. i greatly appreciate it. hello eve

[GENERAL] I need examples of stored procedures returning datasets

2003-09-13 Thread My Deja
I need examples of stored procedures returning datasets. Can anyone point me to some examples? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] MD5() function not available ??

2003-09-13 Thread Marek Lewczuk
Hey, I've searched for MD5 crypting function in PG, but I did not find it. Anyone knows how to implement this function in PG ? Best wishes, Marek L. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archive

[GENERAL] pg 7.3.4 and linux box crash

2003-09-13 Thread pginfo
Hi, I am runing linux red hat 7.3 (standart install) on dual athlon box , 1 GB ram and pg 7.3.4. If I try to access with pgAdmin one from my tables (i contains ~ 1 M records) the linux box crashes. In my pg log I can find: ERROR: Invalid page header in block 5604 of a_acc before this error I see

[GENERAL] how can i use SELECT to find a substring of a column's data?

2003-09-13 Thread JoshuaF
hello everyone i am very new to postgresql 7.3.3 and am using it on my mac G4 OS X and i am having some trouble which i hope you can help me out with some answers to my questions: 1.) How can I get a list of users currently logged into the database? Is it possible? 2) I plan on using postgresql

Re: [GENERAL] PostGreSql database features questions

2003-09-13 Thread Christopher Browne
Ish Ahluwalia <[EMAIL PROTECTED]> writes: > 1) Does PostGreSql allows for multiple databases to be open at the same > time? The backend supports access to multiple databases at the same time. > 2) Does PostGreSql have the ability to tag a Database/Table to be a > persistent or non-persistent da

Re: need for in-place upgrades (was Re: [GENERAL] State of Beta 2)

2003-09-13 Thread Ron Johnson
On Sat, 2003-09-13 at 11:21, Marc G. Fournier wrote: > On Sat, 13 Sep 2003, Ron Johnson wrote: > > > So instead of 1TB of 15K fiber channel disks (and the requisite > > controllers, shelves, RAID overhead, etc), we'd need *two* TB of 15K > > fiber channel disks (and the requisite controllers, shel

[GENERAL] installation of postgres 7.3.4 rpm

2003-09-13 Thread Sharath Kumar
hi. pls help me in installing postgres 7.3.0 rpm for suse linux 8.0. reg sharath ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your me

[GENERAL] ANNOUNCE: Bricolage 1.6.5

2003-09-13 Thread David Wheeler
I'm pleased to announce announce the release of Bricolage 1.6.5. This maintenance release addresses a number issues discovered since the release of version 1.6.4. Some of the more important changes include: * Previewing stories with related media that have no associated file no longe

[GENERAL] "another command is already in progress" error

2003-09-13 Thread frenzy
I am doing asynchronous sql calls using the postgres C library. After doing two PQsendQuery() calls, I get the "another command is already in progress" error. The two calls I am doing are an update, and then an insert, in that order. I am doing this for speed, since my program can't afford to wait

Re: need for in-place upgrades (was Re: [GENERAL] State of Beta 2)

2003-09-13 Thread Dennis Gearon
'k, but is it out of the question to pick up a duplicate server, and use something like eRServer to replicate the databases between the two systems, with the new system having the upgraded database version running on it, and then cutting over once its all in sync? That's just what I was think

Re: [GENERAL] State of Beta 2

2003-09-13 Thread Tom Lane
Kaare Rasmussen <[EMAIL PROTECTED]> writes: >> "interesting" category. It is in the category of things that will only >> happen if people pony up money to pay someone to do uninteresting work. >> And for all the ranting, I've not seen any ponying. > Just for the record now that there's an argumen

Re: need for in-place upgrades (was Re: [GENERAL] State of Beta 2)

2003-09-13 Thread Marc G. Fournier
On Sat, 13 Sep 2003, Ron Johnson wrote: > So instead of 1TB of 15K fiber channel disks (and the requisite > controllers, shelves, RAID overhead, etc), we'd need *two* TB of 15K > fiber channel disks (and the requisite controllers, shelves, RAID > overhead, etc) just for the 1 time per year when

Re: need for in-place upgrades (was Re: [GENERAL] State of Beta 2)

2003-09-13 Thread Marc G. Fournier
On Fri, 12 Sep 2003, Ron Johnson wrote: > On Fri, 2003-09-12 at 17:48, Joshua D. Drake wrote: > > Hello, > > > > The initdb is not always a bad thing. In reality the idea of just > > being able to "upgrade" is not a good thing. Just think about the > > differences between 7.2.3 and 7.3.x... The

Re: [GENERAL] State of Beta 2

2003-09-13 Thread Kaare Rasmussen
Hi > Yes, it's been discussed to death, and it isn't easy. See the archives That's what I thought. > "interesting" category. It is in the category of things that will only > happen if people pony up money to pay someone to do uninteresting work. > And for all the ranting, I've not seen any pon

Re: [GENERAL] psql prompt

2003-09-13 Thread Dennis Bjorklund
On Tue, 12 Aug 2003, Claudio Lapidus wrote: > The command prompt for psql defaults to the database name, but is there a > way to change it to some other string/value? http://www.postgresql.org/docs/7.3/static/app-psql.html#APP-PSQL-PROMPTING -- /Dennis ---(end of broad

need for in-place upgrades (was Re: [GENERAL] State of Beta 2)

2003-09-13 Thread Ron Johnson
On Fri, 2003-09-12 at 17:48, Joshua D. Drake wrote: > Hello, > > The initdb is not always a bad thing. In reality the idea of just > being able to "upgrade" is not a good thing. Just think about the > differences between 7.2.3 and 7.3.x... The most annoying (although > appropriate) one being