> > > database server, a lot of ram will be required for fast operation. I was
> > > thinking at a minimum 256 meg of ram. I also want to have the database run
> > > on a RAID 5 array for speed and fault tolerance. Any suggestions here for
> > > disk type, RAID scheme (software or hardware), contr
I am trying to optimise a query which looks like:
select prod_base.*, manu_base.name from prod_base, manu_base where
prod_base.mid=manu_base.mid;
manu_base is a table consisting of 3000 manufacturer with an id (not
unique to support synonyms) and a name (declared as varchar(32)).
prod_base is a t
Syntax:
postmaster -p
Examples:
postmaster -p 5432
postmaster -p 5433
Cheers,
Ed
Robert Wagner wrote:
> I'm attempting to run two different postmasters on two different HP-UX
> servers, servicing two different apps. The only commonality is that I'm on
> one terminal.
>
> The firs
Hi,
I have a database in Latin2 encoding (Czech stuff) and Latin2/Win1250
on-the-fly recoding with 'set client_encoding' works smoothly. Now, when
I set client encoding to SQL_ASCII, accented characters are converted to
(hexa) codes. Is there any (simple) way to make this recoding convert
accen
I'm attempting to run two different postmasters on two different HP-UX
servers, servicing two different apps. The only commonality is that I'm on
one terminal.
The first starts up OK. When I attempt to start the postmaster on the
other server, I get the error,
FATAL: StreamServerPort: bind() f
"Ross J. Reedstrom" wrote:
>
> On Wed, Dec 15, 1999 at 11:27:36AM -0400, The Hermit Hacker wrote:
> > On Wed, 15 Dec 1999, Jeff Hoffmann wrote:
> >
> > Most of my RAID tests are on Solaris+Disksuite...with good drives
> > in the machine, my writes are something like 18MB/s to the drive, str
On Wed, 15 Dec 1999, Ross J. Reedstrom wrote:
> Ah, this would be a RAID 0+1 setup, then? Very different from Jeff's RAID
> 5 configuration. I'd be willing to believe that software RAID 0+1 _could_
> be faster than most hardware (it's just shuffling and dupping blocks
> around to different drives
On Wed, Dec 15, 1999 at 11:27:36AM -0400, The Hermit Hacker wrote:
> On Wed, 15 Dec 1999, Jeff Hoffmann wrote:
>
> > > my preference tends to be software raid...whatever I've ever seen as far
> > > as hardware raid is concerned has been quite slower then software
> > > raid...and this is with hig
At 08:41 AM 12/15/99 -0500, Adam Rossi wrote:
>I know this question has been asked before. I have seen it in the archives.
>Unfortunately the archives are dead right now (any search will yield "no
>results") and I need to make some decisions.
>
>Can anyone give some general recommendations on hard
On Wed, 15 Dec 1999, J. Roeleveld wrote:
> > What filesystem? I know (thank god) very little about Linux, but
> > there have been comments here by some Linux folks (Thomas, wasn't it
> > you?) that indicated that ext2fs sucks for this? Are you running with
> > fsync() on or off?
>
> What is th
I remember having to do the same thing on a aix oracle installation.
I wrote a little shell script that did it for me.
bob
"Differentiated Software Solutions Pvt. Ltd." wrote:
> Hi,
>
> We have a postgres db which has been crashing about 5 times a day. It must
> be failrly apparent given my oth
> What filesystem? I know (thank god) very little about Linux, but
> there have been comments here by some Linux folks (Thomas, wasn't it
> you?) that indicated that ext2fs sucks for this? Are you running with
> fsync() on or off?
What is the problem with ext2fs? Is it just performance? or is t
On Wed, 15 Dec 1999, Jeff Hoffmann wrote:
> > my preference tends to be software raid...whatever I've ever seen as far
> > as hardware raid is concerned has been quite slower then software
> > raid...and this is with high-end servers...
>
> i kind of question this, and here's why: i just set up
The Hermit Hacker wrote:
>
> On Wed, 15 Dec 1999, Adam Rossi wrote:
>
> > I know this question has been asked before. I have seen it in the archives.
> > Unfortunately the archives are dead right now (any search will yield "no
> > results") and I need to make some decisions.
> >
> > Can anyone g
I just fixed the script that creates the links for the mailing list
archives off of each 'list' page (the 'mbox' link), so that it has the
proper name...
Any other problems, let us know...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub
Moin,
I have two database servers. One running postgresql 6.0
and the new one running 6.5.1.
If I run "psql -h oldone -d oldone -u" from the newer
server and input username and password psql says:
Connection to database 'oldone' failed.
Failed to authenticate client as Postgres user 'olduser'
u
On Wed, 15 Dec 1999, Adam Rossi wrote:
> I know this question has been asked before. I have seen it in the archives.
> Unfortunately the archives are dead right now (any search will yield "no
> results") and I need to make some decisions.
>
> Can anyone give some general recommendations on hardw
I know this question has been asked before. I have seen it in the archives.
Unfortunately the archives are dead right now (any search will yield "no
results") and I need to make some decisions.
Can anyone give some general recommendations on hardware for a server
running Linux (RH6 or 6.1) and Po
Hello,
I can´t get my local Postgres database work with PHP over TCP/IP
(Browser) connection.
PHP 3.12 is installed as Apache-module (Apache 1.3.9)
Postgres version 6.5., both came with my SuSE 6.3
The query script is running without problems at my provider´s machine
(apache 1.3.9, PHP 3.0.7
Karl Eichwalder wrote:
>
> Wim Ceulemans <[EMAIL PROTECTED]> writes:
>
> | I can't seem to install the latest postgresql opn Suse linux 6.3 (kernel
> | 2.2.13, glibc 2.1.2). I always get the following message when I run
> | ./configure :
> |
> | checking for c++... c++
> | checking whe
Hi see this :
test=> select ch from test order by ch ;
ch
--
aa (1)
bb
cc
-- cc --(2)
dd
-- vv --
www
{www} (3)
zz
(9 rows)
test=>
My problem is I want the line (2) appears in first and the line (3
21 matches
Mail list logo
