Re: [ADMIN] Problems with precompiled pgsql on mac

2007-04-10 Thread Peter Elmers
Hi together, The problem is not solved, but we reduced it: it occures only if apple remote desktop is running. So switching off ARD results in a running postgresql system. But this can only be a workaround. Does anybody know why the two programs do not work together? Google says that ARD us

[ADMIN] Process

2007-04-10 Thread Alexander B.
Hi, I have a Postgres server that has more than 500MB ( shared_buffers = 64000) and looking at TOP command, I couldn't understand why appears some process with 536m and other with 23m. What's the difference between? Wouldn't be all process with 536m, including client connections, but not allocati

Re: [ADMIN] Problems with precompiled pgsql on mac

2007-04-10 Thread Tom Lane
Peter Elmers <[EMAIL PROTECTED]> writes: > The problem is not solved, but we reduced it: it occures only if > apple remote desktop is running. So switching off ARD results in a > running postgresql system. > But this can only be a workaround. Does anybody know why the two > programs do not wo

Re: [ADMIN] Process

2007-04-10 Thread Tom Lane
"Alexander B." <[EMAIL PROTECTED]> writes: > I have a Postgres server that has more than 500MB ( shared_buffers = > 64000) and looking at TOP command, I couldn't understand why appears > some process with 536m and other with 23m. > What's the difference between? Some versions of top only count the

Re: [ADMIN] [pgadmin-support] Motivations for PostgreSQL

2007-04-10 Thread Aaron Bono
The problem is, this isn't a logical decision they are making. They are only comfortable with Micro$oft and when I mention a database they haven't heard of before, they cringe even though I have proven it's ability to serve all their needs for the last year. What it comes down to is that I need

Re: [ADMIN] [pgadmin-support] Motivations for PostgreSQL

2007-04-10 Thread Joshua Kramer
Aaron, You might want to probe a little further. Even though you know their reason for wanting SQL Server - "cause it's what they know" - ask them specifically what advantages SQL Server will give them over their current setup. If you know what *they think* their objections are, then you ar

Re: [ADMIN] information about postgresql

2007-04-10 Thread Bastien Continsouzas
> I want to know about POSRGRESQL in full detail. http://www.postgresql.org/docs/8.2/interactive/index.html That was an easy one ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] Restoring single database from an export dump of a cluster

2007-04-10 Thread Bhella, Paramjeet
Hi In our production environment we use pg_dumpall to backup all the databases of a cluster as there are 200+ databases in a cluster. Some times there is a situation where we have to restore a single database from a cluster. According to the postgres docs there is a pg_restore utiltity which can b

[ADMIN] server startup script at boot

2007-04-10 Thread Carl Salvo
Hi, I'm interested in finding out details related to a Postgres server startup script that I can configure to start Postgres at boot. I appreciate any help. Thanks in advance. I appreciate the help. Regards, Carl ---(end of broadcast)--- T

[ADMIN] problems after migration to new hardware

2007-04-10 Thread Geoffrey
We moved our application to a new machine last night. It is a Dell PowerEdge 6950 2X Dual Core. AMD Opteron 8214 2.2Ghz. 8GB Memory. The machine is running Redhat AS 4 Upd 4 and Redhat Cluster Suite. The SAN is an EMC SAS connected via fibre. We are using Postgres 7.4.16. We have recently had s

[ADMIN] Ditributed PosgreSQL

2007-04-10 Thread s kh
hi, I have a question about distributed databases, can we have a ditributed posgresql database now? Does postgreSQL support distributed database system now? Can you send me a good reference for it? thanks. - Sucker-punch spam with award-winning protection. Try th