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

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 reside

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. Poor

[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

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: snip 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

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] 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

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

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

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 same

[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,

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