[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/
[SQL] what utilities do i need for postgres on solaris 7 ??
Hello Everyone, I have an Intel system with solaris 7 installed on it. Now I have d/l'ed postgres 6.5.1 to install it on my system. 1.) What all the utilities are needed before I start compiling and installing the postgres s/w?. I mean to say utilities like gmake. But I could not get gmake from anywhere. 2.) I have read the INSTALL file but could not get how to compile and INSTALL the s/w on Solaris 7. Thanks for all the suggestions. Rajesh. __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/
[SQL] how can I mirror a postgres database
Hi all, I am having postgres6.5 installed on a remote linux server. Now i have installed the same scenario in a local machine. Now i want to update my local machine with any transaction or changes made in remote machine. something like a oracle parallel server. where if one machine breaks down due to some reason the other machine can take over as it has all the data with it. I want to move my complete database with critical data on to postgres. can anybody please suggest how do i do it as the server is a mission critical server. any suggestions are appreciated and thanks for all of the suggestions in advance. Thanks & Regards Rajesh. __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/
[SQL] pg_atoi: error in "template1": can't parse "template1"
Dear all, I have installed postgres 6.5.1 on my RedHat Linux box. The installation went smooth without any problems. Now when i run initdb I got errors. I have seen the Postgres FAQ also and have ensured that all the directories i,e /usr/local/pgsql, /home/postgres etc are owned by postgres super user. I also have set the following environmental variables: - PATH=/usr/bin:/usr/local/bin:/usr/local/pgsql/bin HOME=/home/postgres INPUTRC=/etc/inputrc LC_COLLATE=C SHELL=/bin/bash PGLIB=/usr/local/pgsql/lib USER=postgres PGDATA=/usr/local/pgsql/data MANPATH=:/usr/local/pgsql/man LC_CTYPE=C LANG=en_US OSTYPE=Linux SHLVL=1 LC_COLLATE=C But even then I got errors when I run initdb like Adding template1 database to pg_database... ERROR: pg_atoi: error in "template1": can't parse "template1" ERROR: pg_atoi: error in "template1": can't parse "template1" syntax error 1 : parse errorinitdb: could not log template database initdb: cleaning up. PLEASE help me in this regard. Thanks & Regards Rajesh. __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
