I've searched the documentation and the mailing lists archive but I'm
unable to find info on setting checkpoints and performing roll-forward
operations with the transaction log. I'd appreciate it if someone could
point me to the right docs.
--
Richard Ray
Mississippi State Tax Co
I need to drop a superuser account. I get
dba=# drop role bram;
ERROR: role "bram" cannot be dropped because some objects depend on it
DETAIL: owner of view teacher
owner of type teacher
owner of view temp1
owner of type temp1
...
What is the preferred method.
Thanks
R
On Tue, 10 Oct 2006, Jim C. Nasby wrote:
On Tue, Oct 10, 2006 at 02:22:53PM -0500, Richard Ray wrote:
I need to drop a superuser account. I get
dba=# drop role bram;
ERROR: role "bram" cannot be dropped because some objects depend on it
DETAIL: owner of view teacher
owner of ty
On Tue, 10 Oct 2006, Tom Lane wrote:
Richard Ray <[EMAIL PROTECTED]> writes:
I can reassign the view but not the type.
You don't need to reassign the type's ownership, because it's just part
of the view.
After I reassigned all the views I was allowed to d
to exclude the temp schema?
Richard Ray
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
On Wed, 9 Jan 2008, Bruce Momjian wrote:
Richard Ray wrote:
I've inherited an application that creates a temp schema and stores
a table for each user there.
The data is temporary and does not need to be backed up.
I run pg_dumpall each night.
I can't just delete the tables because us
I have installed pgdg-centos-8.3-5.noarch.rpm
Using that repo I installed
compat-postgresql-libs-4-1PGDG.rhel5
postgresql-server-8.3.5-2PGDG.rhel5
postgresql-contrib-8.3.5-2PGDG.rhel5
postgresql-docs-8.3.5-2PGDG.rhel5
postgresql-libs-8.3.5-2PGDG.rhel5
postgresql-8.3.5-2PGDG.rhel5
postgresql-pltcl-
On Fri, 6 Mar 2009, Jakov Sosic wrote:
On Fri, 6 Mar 2009 09:16:04 -0600 (CST)
Richard Ray wrote:
# yum update postgresql
Have you tried:
# yum update postgresql*
# yum update postgresql*
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
On Fri, 6 Mar 2009, Jakov Sosic wrote:
On Fri, 6 Mar 2009 15:59:08 -0600 (CST)
Richard Ray wrote:
Maybe priorities are broken? Maybe some other repo than pgdg3 has
higher priority for postgresql, and yum then won't upgrade postgresql
because it already has newer version than for ex
ord.
Where should I send messages for help about the lists?
Thanks
Richard Ray
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I'm trying to setup PAM authentication for PostgreSQL. I compiled with PAM
and configured pg_hba.conf:
host test10.3.62.251 255.255.255.255pam
When I try to connect I get:
psql: FATAL 1: PAM authentication failed for user "postgres"
The log shows:
CheckPAMAuth: pam_authent
11 matches
Mail list logo
