Re: [ADMIN] un subscribe

2003-10-27 Thread ezrapostgres
Do it yourself. Go to the mailing list page and unsubscribe lekkala venkata praveen wrote: hai folks, i don't want any mails now, i want to remove my account in u r database please un subscribe me. l.v.praveen _ Using a handphone pr

[ADMIN] un subscribe

2003-10-27 Thread lekkala venkata praveen
hai folks, i don't want any mails now, i want to remove my account in u r database please un subscribe me. l.v.praveen _ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp

[ADMIN] another pg database corruption?

2003-10-27 Thread pginfo
Hi all, I am using pg 7.3.4 on linuz red hat 7.3 and reiserFS. After ~30 days error free work my pg stops. I my log I found: PANIC: open of /mnt/diske/skladdb/pg_clog/0D02 failed: No such file or directory LOG: statement: COPY public.a_sp (ids, ids_ma, ids_mp, ids_mr, ids_mpr, ids_mpdt, ids_mpkt,

Re: [ADMIN] device full ---> postgres will not start

2003-10-27 Thread scott.marlowe
A quick note, anytime you're gonna upgrade, you need to first shut down the postmaster... On Mon, 27 Oct 2003, scott.marlowe wrote: > Assuming you'll be upgrading from 7.2 to 7.2.4, then yes, all you need to > do is upgrage the rpms. you can do tham all at once, assuming they're in > the sa

Re: [ADMIN] Need your help

2003-10-27 Thread Siddharth Rath (sirath)
Hi Devrim, Thanx for the help. Is there anyway to maximize the SHMMAX for the following M/C details : Release: 5.8 Kernel architecture: sun4u Application architecture: sparc Hardware provider: Sun_Microsystems Domain: Kernel version: SunOS 5.8 Generic 108528-17 September 2002 I tried cat /proc/sy

Re: [ADMIN] device full ---> postgres will not start

2003-10-27 Thread scott.marlowe
Assuming you'll be upgrading from 7.2 to 7.2.4, then yes, all you need to do is upgrage the rpms. you can do tham all at once, assuming they're in the same directory and named postgresql-something or other: rpm -Uvh postgresql* should do it. If you want to upgrade to 7.3.4, then you'll need t

Re: [ADMIN] device full ---> postgres will not start

2003-10-27 Thread kbd
i will take the advice and upgrade to 7.2.4 ASAP as in now. this what rpm reports on the server currently: [EMAIL PROTECTED] root]# rpm -qa | grep postgres postgresql-jdbc-7.2.1-5 postgresql-libs-7.2.1-5 postgresql-7.2.1-5 postgresql-server-7.2.1-5 postgresql-contrib-7.2.1-5 postgresql-devel-7.2.1

Re: [ADMIN] Partial/interrupted VACUUM FULL?

2003-10-27 Thread Tom Lane
Jeff Boes <[EMAIL PROTECTED]> writes: > Can I do a VACUUM FULL for a while, and interrupt it (CTRL-C at the psql > prompt) without undoing its progress? No. You can safely interrupt it, but you won't have accomplished anything if you do. regards, tom lane --

Re: [ADMIN] Need your help

2003-10-27 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 27 Oct 2003, Siddharth Rath (sirath) wrote: > at the end of 6th step I did receivethe following in my log file. > I cant reconfigure the kernel with larger SHMMAX. > Please let me know how can I reduce the request size (currently 14991

[ADMIN] Need your help

2003-10-27 Thread Siddharth Rath (sirath)
Title: Message Hi, I'm quite new to PostgresSQL and facing a trouble while trying to install and run as per the guide line.   I did the following : Installing from su systran : 1) ./configure --enable-multibyte --with-perl --without-readline --prefix=/apps/systran/postgresql --bindir=/apps

[ADMIN] Partial/interrupted VACUUM FULL?

2003-10-27 Thread Jeff Boes
We have a pretty large table with many deleted rows. A normal VACUUM of this table now takes over an hour. I'd like to run a full VACUUM to recover the mostly wasted space, but I know it will take several hours. Can I do a VACUUM FULL for a while, and interrupt it (CTRL-C at the psql prompt) wi

Re: [ADMIN] Visibility of objects in other schema's

2003-10-27 Thread Tom Lane
Fred Vos <[EMAIL PROTECTED]> writes: > Since version 7.3 of PostgreSQL it's possible to create schema's. The > User's Guide (paragraph 2.8.4) says that it is not possible to view > objects from a schema you do not own: > "By default, users cannot see the objects in schemas they do not own." Poo

Re: [ADMIN] device full ---> postgres will not start

2003-10-27 Thread scott.marlowe
On Fri, 24 Oct 2003, Duffy House wrote: > Hello: > > It looks like I got caught sleeping. > > I am running Postgresql 7.2 under Red Hat 7.3. > Postgresql failed today. When I tried to restart it, I got a message > stating that the device is full. > I used df to confirm that /var where postgres

Re: [ADMIN] device full ---> postgres will not start

2003-10-27 Thread kbd
Thanks for your reply to my posting. Hope you would be willing to provide some additional assistance. What can I says, I really do not have enough experience to bail, myself out of this one. i did cd /var/lib/pgsql/data then du-sh this reported3.6gig This means I really have a 3.6 gig pos