[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

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

[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

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

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

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