[ADMIN] High load

Oops, i sent this message to pgsql-general. Well, now it goes to the right place. -- Hi guys, i am managing the database server for several sites for my company with postgresql 7.0.3 . These days traffic has been increasing and scripts start to

[ADMIN] starting server problem

I installed postgres on Red Hat 7.0. It was working fine, created a database, inserted records etc. Now when I attempt to start the server with "/etc/rc.d/init.d/postgresql start" I get an error "standard in must be a tty" Any help would be appreciatted. Thanks in advance Mike --

[ADMIN] how to do???

Hi administrtors I get a porblem for PostgresSQL. I don't know how the data (table, users...) of oracle tranfer to PostgresSQL.I don't know Perl program. Are there any way (e.g SQL)to solve this problem? If anyone know, please tell me thank u for help P ---(end of

Re: [ADMIN] Compile directive -8k limit

> What directives do I have to configure when compiling Postgresql 7.1 (on > Solaris and Debian/Gnu Linux) to remove the 8k record size limit? Since version 7.1 there is no limit in the row size. OK, the row size has a limit of 2 GB I think. ---(end of broadcast)---

[ADMIN] Re: HOW-TO migrate database

Hello I use the "-d" switch and data format is correctly exported from database. There's no problem to import table schemes and data to new 7.1.2 Marian Sabo "Tom Lane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "Marian Sabo" <[EMAIL PROTECTED]> writes:

[ADMIN] Please help me

I have to provide a hardware-software configuration based on a PG database, capable to support min 500 simultaneous users each one accesing pages that send an average 6 queries per page. Minimum display time of any page = 5 second. I have no precise idea about how such a configuration will be.

[ADMIN]

hi, i am sorry if this seems like a silly question but i managed to somehow remove the superuser priviliges from my super user...i was experimenting with pg_shadow and now i cant change it back. Is there a way to reassign superuser priviliges to a user since right now there is no one. fareed

Re: [ADMIN] High load

Hi, your first idea should work fine. PostgreSQL 7.1.2 handles 32 clients per default. You can increase this number in postgresql.conf . For more details of options in this file look at: http://www.postgresql.org/idocs/index.php?runtime-config.html I think, i'ts a good idea to lok at the techdoc

Re: [ADMIN] Please help me

Do you plan to use http for your service ? If so, I'd recommend to use following architecture: FE - proxy server is serving incoming requests and provides results to client. It could be very light http server with proxy support. BE - cgi-backend which receive proxied requests, contact with databa

Re: [ADMIN]

"Fareed M. Zaffar" <[EMAIL PROTECTED]> writes: > i am sorry if this seems like a silly question but i managed to > somehow remove the superuser priviliges from my super user...i was > experimenting with pg_shadow and now i cant change it back. Is there a > way to reassign superuser priviliges to a

[ADMIN] error status 139

Hi all, My backend is terminating and I am getting the following error message in the log file: Server process (pid 29620) exited with status 139 at Fri Jul 20 17:14:31 2001 Terminating any active server processes... Server processes were terminated at Fri Jul 20 17:14:31 2001 Any idea what sta

Re: [ADMIN] error status 139

Laurette Cisneros <[EMAIL PROTECTED]> writes: > Any idea what status 139 indicates? SIGSEGV core dump, on most systems. Look for the backend core file (in $PGDATA/base/yourdb/core) and send us a gdb stack trace ... also, it would help to know what PG version you are running, on what platform, an