> # start
>
> /var/log/postgresql.log {
>compress
>rotate 10
>create 0664 postgres postgres
>size=1k
>weekly
>sharedscripts
>postrotate
> /etc/rc.d/init.d/postgresql restart
>endscript
*sigh* I will learn to use my mail client soon to change subjects. My
apologies. :(
Original Message :
--
Greetings.
I just received the following error attempting to do a vacuum on my
database:
freehost=# vacuum analyze;
NOTICE: Rel pg_language: TID 0/1: OID IS INVALID. TU
Greetings.
I just received the following error attempting to do a vacuum on my
database:
freehost=# vacuum analyze;
NOTICE: Rel pg_language: TID 0/1: OID IS INVALID. TUPGONE 1.
ERROR: Index pg_language_oid_index is not a btree
And I see several errors in the logs regarding invalid function c
Greetings.
I'm compiling up PostgreSQL 7.0.03 on a Ultra60 running Solaris 8. It
compiles fine, but there are some questions I have regarding the parallel
regression tests that I performed afterwards.
During the tests I get the folloing errors from the script :
sequential test create_function
Greetings.
I have a smallish sized database that's getting alot of update transactions
to it. It's been running fine over the past several weeks, but suddenly I'm
starting to see :
NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause.
NOTICE: current transaction is a
Greetings.
I have a postgresql database installed on a drive that's gone flakey. I'm
about to replace the drive, and wondering about one small point.
Is it safe to just shut down the database, tar everything up, replace the
drive, untar, and start it back up? None of the paths, etc, are going
Greetings.
We've recently been seeing several database crashes. The last things seen
in the logs are :
postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
FATAL 1: ReleaseLruFile: No open files available to be
> Some time ago I saw the someone give an example of how to combine a
> query result with test using sql.
> What i have is a table with f_name varchar l_name varchar and I want the
> result to say [EMAIL PROTECTED]
> Is this possible I will redirect the output to a textfile using the \o
> option.
em.
Though I'm also fairly new to PostgreSQL, so this could also be 'dynamite
fishing' ;)
Sincerely, Warren
-
Warren Vanichuk, Systems Engineer,
Street Light Productions Ltd.
Greetings.
I am writting up a function in PL/pgSQL to automate a couple of multi-table
updates, and I have a question.
I need to check to see if the data is already in the database, and if it is,
perform and update, or if it's not, perform an insert. The lookup is
against a primary key, so I o
10 matches
Mail list logo
