On Sat, 2003-10-18 at 22:15, Eric M. Wulff wrote:
> This is very helpful. My next problem is setting up a db. createdb fails...
>
> "psql: FATAL: user "blah" does not exist
> createdb: database creation failed"
>
> The user is either myself or root. Of course, doesn't like root. How
> do I
> we have made 4 databases in postgresql, now we want to know how can be
> recognize these database files in /var/lib/pgsql/data/base.
Execute this query:
select datname, datid from pg_stat_database;
Bye, Chris.
---(end of broadcast)---
TIP 6
> after login into pgsql through a user, when i try to connect some other
> database it always says that permission denied.
> what do i do?
Read this about pg_hba.conf:
http://www.postgresql.org/docs/7.3/static/client-authentication.html
And this about DB users:
http://www.postgresql.org/docs/7
> i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
> When the memory usage reached 80% or more of the total memory in the
> system..
> the memory just keep stuck there..The thing did not reduce bt itself...
>
> Then i decided to stop the postgresql service. But ...the m
> > How do I uninstall pgAdmin III? Please help
> pgAdmin is installed on linux redhat 8.
If you used rpm (redhat package manager) to install it, you can
uninstall it with:
rpm -e pgadmin3
Bye, Chris.
---(end of broadcast)---
TIP 2: you can
g/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hi, I've installed PostgreSQL on a RedHat 6.0 i386 box. The compile and
everything seemed to go fine. I'm now logged in as the superuser
(postgresql) following the install instructions in the docs. postmaster
is indeed running. PGLIB and PGDATA are properly set
(PGLIB=/usr/local/pgsql/lib and
Compiling PostgreSQL 8.0.3 under SCO OpsenServer6 following problems come
out:
Unzip the PGSQL-code you get old files of config.guess und config.sub,
which occurs an error.
The message of the errors includes a link where you can get the new version
of these files, but this link is wrong.
