Re: [ADMIN] Postgres Log Rolling

Naomi, We're using Red Hat Linux logrotate to do this A file we called pgsql is put in the /etc/logrotate.d directory, it's contents are as follows /var/log/pgsql { rotate 5 copytruncate daily size=1k } This rotates the log files each morning when the daily cron jobs are run. We

Re: [ADMIN] pg_dump and pg_dumpall error

On 20 Feb 2002, Srinivasa Rao Chava wrote: > Hai, > I have built postgresql 7.2.0 from CVS tree to fix the pg_dump and > pg_dumpall > problems. But even after installing it from cvs file, it is still > giving the same errors. The previous veriosn is 7.1.3 from which I > took pg_dumpall. > I co

Re: [ADMIN] How to set time zone permanently

Tom Lane wrote: > Pam Wampler <[EMAIL PROTECTED]> writes: > > Where do I & how do I permanently set the time zone? > > I think best/only way right now is to set the TZ environment variable > before starting the postmaster. The TimeZone variable ought to be > settable from postgresql.conf, but f

[ADMIN] pg_dump and pg_dumpall error

Hai, I have built postgresql 7.2.0 from CVS tree to fix the pg_dump and pg_dumpall problems. But even after installing it from cvs file, it is still giving the same errors. The previous veriosn is 7.1.3 from which I took pg_dumpall. I could not restore the database in 7.2 with psql. Is there any

[ADMIN] Building binary...

I'm trying to build the binaries of Postgresql 7.2 for Redhat 7.1 This was the resoult: root@XXX> rpm --rebuild postgresql-7.2-1PGDG.src.rpm Installing postgresql-7.2-1PGDG.src.rpm error: failed build dependencies: gettext >= 0.10.36 is needed by postgresql-7.2-1PGDG I tried to find a new b

Re: [ADMIN] Postgres Log Rolling

Naomi Walker <[EMAIL PROTECTED]> writes: > Do I have to bounce the cluster to roll the log? How should I be > performing this task? There's some discussion of this point in the 7.2 docs: http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/logfile-maintenance.html

[ADMIN] Postgres Log Rolling

This should be an easy one, but.. We need to start rolling our postgres error logs. I wondered whether or not I could pull the rug out from under postgres by just renaming the pgsql.log to 'date'.log and then recreating (touch pgsql.log) the log. I then vacuum'd a database (so it would w

Re: [ADMIN] Postgresql 7.2 on Red-hat 7.1

Gaetano Mendola writes: > Why not exist the bin of 7.2 for Red hat 7.1? Nobody has volunteered to build one. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate s

Re: [ADMIN] Postgresql 7.2 on Red-hat 7.1

"Peter Eisentraut" <[EMAIL PROTECTED]> wrote: > Gaetano Mendola writes: > > > Why not exist the bin of 7.2 for Red hat 7.1? > > Nobody has volunteered to build one. I'm but I don't know how, anyone can help me ? Ciao Gaetano -- #exclude #include printf("\t\t\b\b\b\b\b\b");. printf("\t\t\

[ADMIN] Postgresql 7.2 on Red-hat 7.1

Why not exist the bin of 7.2 for Red hat 7.1? Ciao Gaetano -- #exclude #include printf("\t\t\b\b\b\b\b\b");. printf("\t\t\b\b\b\b\b\b"); ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-loun

Re: [ADMIN] How to set time zone permanently

Thanks Tom That worked !!! I added /etc/TIMEZONE & put TZ=EST export TZ in that file then in /etc/profile I added #prw added 2/20/2002 for timezone # Set the TIMEZONE if [ -r /etc/TIMEZONE ] then . /etc/TIMEZONE then logged out as postgres user & back

Re: [ADMIN] How to set time zone permanently

Pam Wampler <[EMAIL PROTECTED]> writes: > Where do I & how do I permanently set the time zone? I think best/only way right now is to set the TZ environment variable before starting the postmaster. The TimeZone variable ought to be settable from postgresql.conf, but for some reason it's not ther

Re: [ADMIN] PL/pgSQL location in RH7.2?

Rasmus Mohr <[EMAIL PROTECTED]> writes: > Does anyone know in which directory PL/pgSQL is located in Red Hat 7.2? [tgl@rh1 tgl]$ rpm -ql `rpm -qa | grep postgres` | grep plpgsql /usr/share/doc/postgresql-7.1.3/html/plpgsql-description.html /usr/share/doc/postgresql-7.1.3/html/plpgsql-examples.htm

Re: [ADMIN] Time problem

"Jaya Swarup" <[EMAIL PROTECTED]> writes: > 3) BUT, when I am retrieving data from the sql query (code) and displaying > it, it is inexplicably ahead of the System time by exactly 30 mins. Sure sounds like you are running in some odd time zone. > 4) I have tried setting the TIME ZONE variable to

[ADMIN] How to set time zone permanently

How do you set the time zone permanently in postgresql? I can use the set time zone 'EST' in psql on template1 show time zone & it shows EST exit then go back into psql & do a show time zone & it says time zone unknown Where do I & how do I permanently set the time zone? thanks Pam Wamper ---

[ADMIN] Time problem

Hi All, I have installed postgres 7.1.3 as database. For my application I have used timestamp as the datatype for date and time. I am facing the following problem: 1) While inserting data, I do not have any trouble and the time taken is the system time. 2) In the console when I select data it s

[ADMIN] PL/pgSQL location in RH7.2?

Does anyone know in which directory PL/pgSQL is located in Red Hat 7.2? I supposed to add this language to an existing postgreSQL installation using 'createlang' but so far I've been unable to located the pgsql/bin directory :-( -- Rasm

[ADMIN] database by error

hi all: the other day i created a database with postgresql 7.2 but i create a database with special caracters. now i cant drop database because i dont know how i can print special caracters. my question is: there are any way to drop database without command dropdb and without write the database no