[SQL] shmget fails for min buffers of postmaster also on solaris 7 .....
Dear All, I have installed postgres 7.0.2 on solaris 7 on an intel based machine. But, when I am trying to run the postmaster( the database startup) with minimum buffers also it gives the following error IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1104896, per mission=600 This type of error is usually caused by an improper shared memory or System V IPC semaphore configuration. For more information, see the FAQ and platform-specific FAQ's in the source directory pgsql/doc or on our web site at http://www.postgresql.org. FATAL 1: ShmemCreate: cannot create region Then I have read the POSTGRES on SOLARIS and other FAQ's and then edited the /etc/system file and added the following entries to increase the shared memory size to 128MB. set shmsys:shminfo_shmmax=268435456 set shmsys:shminfo_shmmin=200 set shmsys:shminfo_shmmni=200 set shmsys:shminfo_shmseg=200 set semsys:seminfo_semmap=250 set semsys:seminfo_semmni=500 set semsys:seminfo_semmns=500 set semsys:seminfo_semmsl=500 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=100 Inspite of this I am unable to start the postmaster. Can anybody Please suggest me a solution for this problem. It would be of great help if someone can suggest me what all changes in the OS or postgres are to be made for starting postmaster with 512 buffers. Thanks for all suggestions. Thanks & Regards Rajesh. __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/
Re: [SQL] shmget fails for min buffers of postmaster also on solaris 7 .....
> >Then I have read the POSTGRES on SOLARIS and other >FAQ's and then edited the /etc/system file and added >the following entries to increase the shared memory >size to 128MB. > > >set shmsys:shminfo_shmmax=268435456 >set shmsys:shminfo_shmmin=200 >set shmsys:shminfo_shmmni=200 >set shmsys:shminfo_shmseg=200 >set semsys:seminfo_semmap=250 >set semsys:seminfo_semmni=500 >set semsys:seminfo_semmns=500 >set semsys:seminfo_semmsl=500 >set semsys:seminfo_semmnu=500 >set semsys:seminfo_semume=100 > > >Inspite of this I am unable to start the postmaster. Well, we had similar problems on Solaris 5.6 some time before. I think we had to add the following lines to /etc/system to make it work: forceload: sys/semsys forceload: sys/shmsys So we have the following lines added to /etc/system, although I am no longer clear about what of these was necessary to start postgres: forceload: sys/semsys forceload: sys/shmsys set shmsys:shminfo_shmmax=268435456 set shmsys:shminfo_shmseg=20 set semsys:seminfo_semmap=250 set semsys:seminfo_semmni=500 set semsys:seminfo_semmns=1024 set semsys:seminfo_semmsl=500 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=100 set semsys:seminfo_semmni=200 Thomas Mack TU Braunschweig, Abt. Informationssysteme
[SQL] info about tables
Hi, I want drop some tables, is there any way to get the info which can show when the tables were used last time? I mean that I want know when this table is used last time? -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.ipinc.com
[SQL] Division
Hi, I tried the write up the following SQL statement: result1 from sql1 = (1,2,3,4,5) result2 from sql2 = (4,5) result3 = result1/result2 (or is it result2/result1) = (1,2,3) What do I have to do to get the (1,2,3) result? I tried "query EXCEPT query", but it seems like EXCEPT needs both tables in queries to be of the same number of columns and column types. And (any, all, exist) doesn't seem to be a right solution. Thanks for help. - Bernie begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:Programmer x-mozilla-cpt:;0 fn:Bernie Huang end:vcard
Re: [SQL] Division
Hi, there, I don't quit sure what you really want to solve, however, if you use EXCEPT results1 and result2 should be same type rather than tables, i.e. select a,b from tab1 except select c,d from tab2; a,c are same type b,d are same type. notes, EXCEPT to big table is not efficient, so does IN clause. Bernie Huang wrote: > Hi, > > I tried the write up the following SQL statement: > > result1 from sql1 = (1,2,3,4,5) > result2 from sql2 = (4,5) > result3 = result1/result2 (or is it result2/result1) = (1,2,3) > > What do I have to do to get the (1,2,3) result? I tried "query EXCEPT > query", but it seems like EXCEPT needs both tables in queries to be of > the same number of columns and column types. And (any, all, exist) > doesn't seem to be a right solution. > > Thanks for help. > > - Bernie -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.ipinc.com
