[GENERAL] We are doing great things with PostgreSQL

I took some time last night to go to DejaNews (www.dejanews.com), and do a search for PostgreSQL, ordered by date. I looked at Usenet posting from the past two weeks that mention PostgreSQL. I did this about a year ago, and was disappointed in what I saw. There were not many postings that menti

[GENERAL] Postgres on Sun Solaris 2.5.1

We are trying to upgrade our present Postgres 6.3.2 database running on Linux/i386 to v6.4.2 on Sun Solaris 2.5.1. I tried to compile the server using GCC for Solris 2.5.1. Everything went well except while running the regression tests, which failed giving these messages: + ERROR: Load of file /b

Re: [GENERAL] pg_dump

On Wed, 6 Jan 1999, David Giffin wrote: # I was wondering if there was a way to get pg_dump to dump the rights for # the tables? I know that pg_dumpall seems to do it. But I only want to # dump one database not the whole server. verde:~ 104> pg_dump -h pg_dump: ERROR: Option requires an argumen

[GENERAL] pg_dump

Hello, I was wondering if there was a way to get pg_dump to dump the rights for the tables? I know that pg_dumpall seems to do it. But I only want to dump one database not the whole server. Thanks, David

[GENERAL] SPI

I'm installing v6.4.2 on Solaris 2.5.1. Everything goes well until I run the regression test. Some of the test fails with an error message like: + ERROR: Load of file /bytek/postgres/postgresql-6.4.2/src/test/regress/input/. ./regress.so failed: ld.so.1: /bytek/postgres/bin/postmaster: fatal: rel

[GENERAL] PostgreSQL 6.4.1 backup procedure on live web server

Forgive me if I send this to the wrong address; this is my first post to this list. I have looked at previous posts regarding backup. All that I have seen say to use pg_dump during time of inactivity. However, on a business web server that is active 24/7, will it still be stable? I have test

[GENERAL] Subject: String Concatenation does not work.

>I tried to place a query like "SELECT * FROM x WHERE a = b || c" where > a, b and c are text columns in table x. > Unfortunately all I get are Syntax Errors pointing to the concatenation > operator. This happens under 6.3. with psql and jdbc. > Am I just tripping over a bug or do have to use some

Re: [GENERAL] Patch 6.4.1 to 6.4.2

> >There is no patch for this...we've tried in the past to create "clean" > >patches, and each time so problem arose from it... > > > >In the case of v6.4.1 -> v6.4.2, its even worse, since the reason that > >v6.4.2 was released was because v6.4.1 was a mis-package...I erroneously > >packaged up o

Re: [GENERAL] Patch 6.4.1 to 6.4.2

>There is no patch for this...we've tried in the past to create "clean" >patches, and each time so problem arose from it... > >In the case of v6.4.1 -> v6.4.2, its even worse, since the reason that >v6.4.2 was released was because v6.4.1 was a mis-package...I erroneously >packaged up our -CURRENT

Re: [GENERAL] Patch 6.4.1 to 6.4.2

On Wed, 6 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote: > > Hi! > > Where can I find the required patch to upgrade 6.4.1 to 6.4.2 ? There is no patch for this...we've tried in the past to create "clean" patches, and each time so problem arose from it... In the case of v6.4.1 -> v6.4.2, it

[GENERAL] Patch 6.4.1 to 6.4.2

Hi! Where can I find the required patch to upgrade 6.4.1 to 6.4.2 ? I am reluctant to download 5.x Mb each time a minor update is released. (6.4, 6.4.1, an now 6.4.2 = 17Mb!) Please note that I've already check psql-patches mailing list archives... Is /pub/patches supposed to be almost empty