So did initdb execute without errors after you changed the home directory?
It looks like your postgresql.conf file is pointing Postgres to log to a
directory / file that the Postgres user doesn't have permission to write to.
~p
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PR
"Phillip Smith" <[EMAIL PROTECTED]> wrote:
> My bad - is has the shell, but as you say, the home
> directory is /dev/null
>
> niutil -destroyval -u admin . /users/postgres home
> /dev/null niutil -appendprop -u admin . /users/postgres
> home /Library/postgreSQL8
>
> Once again, use at your own ris
My bad - is has the shell, but as you say, the home directory is /dev/null
NOW, I must preface this with a warning saying that I have NOT tested this,
and do not guarantee that it will work. I found it on a Mac forum and have
never tried it, or seen confirmation that it will work. Follow on at you
Hello People,
My thanks to the several people who gave suggestions for how
to solve my initdb problem.
1. "Phillip Smith" <[EMAIL PROTECTED]>
suggested the problems stemmed from:
the 'postgres' user not having a correct shell login setup.
It looks like the home directory is set to /dev/null whic
Andrew Kelly wrote:
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-data
Hi,
On Wed, 2007-06-20 at 19:44 +0530, [EMAIL PROTECTED] wrote:
> Please help me in this matter.
I think "rpm -Uvh postgresql-libs, server, etc" will help you.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated H
You can also use the following query to check the autovacuum activity:
select last_autovacuum, last_autoanalyze from
"pg_catalog"."pg_stat_all_tables"
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Sibte Abbas napisał(a):
> On 6/20/07
Sibte Abbas napisał(a):
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Hello,
How can I make sure that autovacuum is running, beyond believing that
all autovacuum_ settings in
postgresql.conf are set correctly?
In the 8.1 I could see:
LOG: autovacuum: processing database "test"
in
On Wed, Jun 20, 2007 at 11:59:11AM -0400, Carol Walter wrote:
> I hope this is a simple request, but I'm a relative newby and I don't
> know my way around the system tables yet. My user wants to know who
> has privs to a specific database. How can I give her this info.
You could use the acce
George Wilk wrote:
> According to the WAL config documentation correctly, checkpoints are created
> every
> admin3.chm::/pg/runtime-config-wal.html#guc-checkpoint-segments>
> checkpoint_segments log segments, or every
> admin3.chm::/pg/runtime-config-wal.html#guc-checkpoint-timeout>
> checkpoint_
George Wilk wrote:
However, it seems as though setting
my checkpoint_timeout has no effect on checkpoint creation ( I have it
set to 30 seconds). Forcing checkpoint by running */psql –c CHECKPOINT
mydb/* doesn’t do the trick either. Checkpoints are created solely
based on the checkpoint_se
According to the WAL config documentation correctly, checkpoints are created
every
checkpoint_segments log segments, or every
checkpoint_timeout seconds, whichever comes first. However, it seems as
though setting my checkpoint_timeout has no effect on checkpoint creation (
I have it set to 30 se
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Hello,
How can I make sure that autovacuum is running, beyond believing that all
autovacuum_ settings in
postgresql.conf are set correctly?
In the 8.1 I could see:
LOG: autovacuum: processing database "test"
in the log.
But I can't find i
Hello,
How can I make sure that autovacuum is running, beyond believing that all autovacuum_ settings in
postgresql.conf are set correctly?
In the 8.1 I could see:
LOG: autovacuum: processing database "test"
in the log.
But I can't find it in the 8.2.4.
I could see some developers discussio
rpm -e postgresql-libs-7.4.8*
error: Failed dependencies:
libpq.so is needed by (installed) postgresql-server-7.4.17-1PGDG.i686
rpm -e --nodeps post...
Regards,
Ben K.
Developer
http://benix.tamu.edu
---(end of broadcast)---
TIP 5: don't forget
I hope this is a simple request, but I'm a relative newby and I don't
know my way around the system tables yet. My user wants to know who
has privs to a specific database. How can I give her this info.
Carol
---(end of broadcast)---
TIP 3: Ha
"Ira Berdichevsky" <[EMAIL PROTECTED]> writes:
> I checked with "psql -h 10.0.0.40 -p 5433" command and saw that
> PostgreSQL respond it.
> The problem is I still couldn't connect to PostgreSQL from Windows
> pgAdmin agent.
> I have this error connection: "Server doesn't listen".
> I don't have pro
Hi All,
I was able to install postgresql-7.4.17-1PGDG.x86_64.rpm and
postgresql-server-7.4.17-1PGDG.x86_64.rpm.
After that probably you mentioned the wrong order "devel" has a
pre-requisite on "libs" rpm.
When I tried to install "libs" i was faced with following error.
rpm -ivv postgresql-libs-7
Thanks, all. Just an FYI to wrap up the thread.
>>> On Mon, Jun 18, 2007 at 3:25 PM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> I'm suspicious that either the controller
>> didn't persist dirty pages in the June 14th fai
Seems to be a permissions problem, make sure your /Library/postgreSQL8/
directory is owned by the postgres user. If you installed using binaries as
root you have to chown /Library/postgreSQL8/ -R (this is what you do in Linux).
Hope that helps.
S
-Original Message-
From: [EMAIL PROTECT
On 6/20/07, Ira Berdichevsky <[EMAIL PROTECTED]> wrote:
Hi,
I have some problem to configure PostgreSQL .
My OS is RedHat Enterprise 4 Linux9 32 bits) , I installed PostgreSQL
version 8.2.4.
I configured database : initdb -D /var/lib/pgsql/data -U postgres .
I changed pg_hba.conf and postgresql
firewall?
On Wed, Jun 20, 2007 at 12:09:32AM -0700, Ira Berdichevsky wrote:
> Hi,
> I have some problem to configure PostgreSQL .
> My OS is RedHat Enterprise 4 Linux9 32 bits) , I installed PostgreSQL
> version 8.2.4.
> I configured database : initdb -D /var/lib/pgsql/data -U postgres .
> I chang
Hi,
I have some problem to configure PostgreSQL .
My OS is RedHat Enterprise 4 Linux9 32 bits) , I installed PostgreSQL
version 8.2.4.
I configured database : initdb -D /var/lib/pgsql/data -U postgres .
I changed pg_hba.conf and postgresql.config files :
pg_hba.conf:
localallall
23 matches
Mail list logo
