Eric,
The pg_hba.conf file is what you would want to use. There are good docs
on it within the file with examples and in the 7.1 online docs. I will
throw a couple quick examples here for you.
Trust all users to any database from any connection
hostall 0.0.0.0 0.0.0.0 trust
The Install readmes specifically say to use gmake. gmake and make are
two different animals. Good luck.
-Original Message-
From: Jeremy May [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 22, 2001 2:58 AM
To: [EMAIL PROTECTED]
Subject: [ADMIN] Re: Install Problems
i have no gmake i downl
Toma Vailikit writes:
> The Install readmes specifically say to use gmake. gmake and make are
> two different animals. Good luck.
The INSTALL file specifically says
On GNU/Linux systems GNU make is the default tool with the name make.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.
Hi everyone, I'm more or less new to PostgreSQL and am trying to setup a
rather large database for a data analysis application. Data is collected
and dropped into a single table, which will become ~20GB. Analysis happens
on a Windows client (over a network) that queries the data in chunks acros
[EMAIL PROTECTED] writes:
> Hi everyone, I'm more or less new to PostgreSQL and am trying to setup a
> rather large database for a data analysis application. Data is collected
> and dropped into a single table, which will become ~20GB. Analysis happens
> on a Windows client (over a network) tha
pgsql/PG_VERSION says "7.0". postmaster --version and psql --version don't
tell me anything.
If the machine is completely dedicated to this database, under what
conditions would the kernel make such decisions? Where can I find more
information on this? Are there other users with similar requir
On Sun, Apr 22, 2001 at 05:12:20PM -0400, [EMAIL PROTECTED] wrote:
> My problem is this: during the query process the hard drive is being tagged
> excessively, while the cpu's are idling at 50% (numbers from Linux command:
> top), and this is bringing down the speed pretty dramatically since the
I'm spawning 6 backends to query the data. top lists 6 postmaster processes
working, and therefore the idle time should hit 0% easily. Also, the hard
drive light goes nuts when I'm running this.
Here is the pertinent information from top. To be clear, I'm NOT spawning a
new postmaster per chun
I'm new at PostgreSQL.
So far, succesfully compiled & installed it. Created a db, created a table,
and 'copied' tab-delim data into it.
Also downloaded and installed Perl Pg mod (that was a pain; had to sen ENV
variables, and had to force install because of the "root" does not exist
error in mak
> [EMAIL PROTECTED] writes:
> > Hi everyone, I'm more or less new to PostgreSQL and am trying to setup a
> > rather large database for a data analysis application. Data is collected
> > and dropped into a single table, which will become ~20GB. Analysis happens
> > on a Windows client (over a ne
> 27 processes: 24 sleeping, 3 running, 0 zombie, 0 stopped
> CPU states: 16.3% user, 3.8% system, 0.0% nice, 79.8% idle
> Mem: 517292K av, 508400K used, 8892K free, 9K shrd, 197224K buff
> Swap: 65988K av, 0K used, 65988K free160740K cached
>
I see zero swap use
> use Pg;
> $conn = Pg::connectdb("dbname=tasbill");
> $res = $conn->exec("SELECT * from cust");
> while (@row = $res->fetchrow) {
> print join(" ", @row);
> }
>
>
> Works fine if I log in as 'postgres' before executing script, but fails if
> logged in as any other user.
on 4/22/01 11:25 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
>> use Pg;
>> $conn = Pg::connectdb("dbname=tasbill");
>> $res = $conn->exec("SELECT * from cust");
>> while (@row = $res->fetchrow) {
>> print join(" ", @row);
>> }
>>
>>
>> Works fine if I log in as 'postgres' before executin
>> 27 processes: 24 sleeping, 3 running, 0 zombie, 0 stopped
>> CPU states: 16.3% user, 3.8% system, 0.0% nice, 79.8% idle
>> Mem: 517292K av, 508400K used, 8892K free, 9K shrd, 197224K buff
>> Swap: 65988K av, 0K used, 65988K free160740K cached
These numbers don'
I found that postgresql-perl installed plpgsql.so in /usr/lib, instead of
/usr/lib/pgsql
My import of a 7.0 database used pl/pgsql and it errored on import (psql xyz
< dump) saying that /usr/lib/pgsql/plpgsql.so not found.
For what it's worth.
-dan
"David Lizano" <[EMAIL PROTECTED]> wrote in me
when i ./configure
It works fine dose everything fine
i do "# make"
and get :
gcc -I../include -I../backend -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -o postgres access/SUBSYS.o bootstrap/SUBSYS.o
catalog/SUBSYS.ocommands/SUBSYS.o exe
i have no gmake i downloaded latest GNU make
GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for i686-pc-linux-gnu
- Original Message -
From: mike <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; Jeremy D. May <[EMAIL PROTECTED]>
Sent: Saturday, April 21, 2001 11:43 P
- Original Message -
From: "Lamar Owen" <[EMAIL PROTECTED]>
To: "David Lizano" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 7:29 PM
Subject: Re: Bugs in PostgreSQL v7.1 rpms for RedHat
> Works here, for some reason. But I'll check it. I run these very RP
you need to use gmake to compile postgres
./configure
gmake
gmake install
Mike
- Original Message -
From: "Jeremy D. May" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 4:48 PM
Subject: Install Problems
> when i ./configure
> It works fine dose everything
Thomas Weholt <[EMAIL PROTECTED]> wrote:
>Where can I find debian packages for PostgreSQL 7.1 ??
There are none yet AFAIK. Packages of 7.1RC versions are available from
http://people.debian.org/~elphick/postgresql/index.html , and I've been able
to build 7.1 under "unstable" using the diff for RC
20 matches
Mail list logo
