[ADMIN] Need some shmget advice
Architecture: Solaris 2.6 Sparc Compiler: gcc 2.95.1 postgres versionpostgres-v6.5.3 I am getting this no matter what value I pass to postmaster -B. There is something else going on here. I did have some problems with the compile but got the problems worked out. Any suggestions? IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120, permission=700 IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010, size=120, permission=0 IpcMemoryAttach: shmat failed (Invalid argument) id=-2 FATAL 1: AttachSLockMemory: could not attach segment Regards, Drew Hamilton
Re: [ADMIN] Need some shmget advice
what does ipcs -a show? On Wed, 12 Apr 2000, Hamilton, Andrew Mr. wrote: Architecture: Solaris 2.6 Sparc Compiler: gcc 2.95.1 postgres version postgres-v6.5.3 I am getting this no matter what value I pass to postmaster -B. There is something else going on here. I did have some problems with the compile but got the problems worked out. Any suggestions? IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120, permission=700 IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010, size=120, permission=0 IpcMemoryAttach: shmat failed (Invalid argument) id=-2 FATAL 1: AttachSLockMemory: could not attach segment Regards, Drew Hamilton Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
[ADMIN] Emergency questions for new bie
Hi, I'm an Oracle DBA, lately I began a project work on PostgreSQL 6.5.3 for Red Hat Linux 6.0. Every thing is fine, except: 1.How can I enable PG run as 'no-fsync' mode to improve performance? How can I check PG is in 'fsync' mode or not? 2. We have a table contain a column which use 'timestamp' data type. 'cause we need both date and time in this column, and don't want to break it into two columns with 'date' and 'time' data type(if so, we may have to change thousands of lines code, it origrinally works on Oracle). But when I tried to create an index on this 'timestamp' column, I got this error and creating failed: 'Cannot find a default operator class for type 1296.' I use this SQL command to create index: create index ind_name on tab_name(col_name); Can't I create index on 'timestamp' column? Right now since there's no index on this column, our app runs very very slow! THanks a lot! Jack
Re: [ADMIN] Emergency questions for new bie
Jack Zhu writes: 1.How can I enable PG run as 'no-fsync' mode to improve performance? postmaster -o '-F' How can I check PG is in 'fsync' mode or not? It is if and only if you give the above option. But when I tried to create an index on this 'timestamp' column, I got this error and creating failed: 'Cannot find a default operator class for type 1296.' Indexes don't work for timestamp in 6.5. Use datetime, or better yet upgrade to 7.0 which should be out in a few weeks. (jinx) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden
Re: [ADMIN] Need some shmget advice
On Wed, 12 Apr 2000, Hamilton, Andrew Mr. wrote: Architecture: Solaris 2.6 Sparc Compiler: gcc 2.95.1 postgres version postgres-v6.5.3 I am getting this no matter what value I pass to postmaster -B. There is something else going on here. I did have some problems with the compile but got the problems worked out. Any suggestions? I'm willing to guess that you're running 2.3.99pre? # mkdir /var/shm # mount -t shm none /var/shm
[ADMIN] After creating user
Hello, I created new user, changed ownership of my database. But how can my user work with database if command 'psql' from UNIX can run only 'postgres' user? Thanks Mike __ Do You Yahoo!? Send online invitations with Yahoo! Invites. http://invites.yahoo.com