Re: [ADMIN] Request for help

2013-08-09 Thread Jan Lentfer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 09.08.2013 21:49, schrieb ramana...@gmail.com: > We have recently converted our db2 database to PostgreSQL and we > stuck on one thing I,e Authentication of users. > > Let me explain what was in DB2, > > We have a unix group "mhubrpt" on DB2 unix

Re: [ADMIN] Clarification when using Continous Archiving in 8.4

2013-08-09 Thread Jan Lentfer
On Thu, 8 Aug 2013 21:36:35 -0400, Bruce Momjian wrote: > On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote: > >> Hello People, In reference to my last post , my question is: It is possible to recover more (subsequent) WAL files when I have already recover a postgres 8.4 databas

Re: [ADMIN] Recommended way to dump multi db cluster

2013-08-08 Thread Jan Lentfer
On Thu, 08 Aug 2013 10:56:19 +0200, lst_ho...@kwsoft.de wrote: as of now we do a pg_dumpall on most of our PostgreSQL instances. This has some drawbacks when restore of only one of the databases is required, because from what i can see pg_restore is not able to limit the restore to one database

Re: [ADMIN] "Data import from Mysql to MS Sql Server"

2012-07-26 Thread Jan Lentfer
Hi Rajat, On Thu, 26 Jul 2012 13:16:42 +0530, Rajat Sangal wrote: I want to import Data from MySql to MS Sql Server 2008 using vb.net. So please help me. Pls give me reply as soon possible. MySQL, MS SQL, vb? I think you are on the wrong list :) Jan -- professional: http://www.oscar-consult.

Re: [ADMIN] Creating a Read Only profile in 8.4

2012-06-08 Thread Jan Lentfer
On Fri, 8 Jun 2012 08:29:30 -0400, Della-Croce, Gregory wrote: The commands worked fine. But when I connected as RO_User and did a select against a simple table in the DB, I got access denied on the table. Check the permissions for that user on the schema public, too. Jan -- professional: htt

Re: [ADMIN] Advice/guideline on increasing shared_buffers and kernel parameters

2012-05-08 Thread Jan Lentfer
On Tue, 8 May 2012 14:56:52 +0530, Gnanakumar wrote: As you can see, in my case, I'm setting only 3 GB (3072 MB), which is actually below 8 GB. So, I need to increase kernel parameters in this case. Any ideas/insights? I am not using CentOS (or Linux at all), but edit /etc/sysctl.conf and

Re: [ADMIN] Advice/guideline on increasing shared_buffers and kernel parameters

2012-05-08 Thread Jan Lentfer
Hi Gnanam, On Tue, 8 May 2012 12:22:58 +0530, Gnanakumar wrote: Our Production server has got 35 GB physical RAM size. Since the server has lots of RAM, we want to really make use of it. We've already configured "max_connections" to 1000 and "shared_buffers" to 1536 MB, but when we tried t

Re: [ADMIN] Very long " in transaction" query

2012-05-03 Thread Jan Lentfer
On Thu, 3 May 2012 15:48:35 +0530, Gnanakumar wrote: Hi, Recently, in our Production server, we found a "single query" being held up in " in transaction" for more than 19 hours using the following query: [...] Usually these are application problems, not database ones. E.g. a piece of code

Re: [ADMIN] Disable TRUST authentication mode

2012-03-10 Thread Jan Lentfer
Am 10.03.2012 16:21, schrieb c k: It we can disable the TRUST mode then every user have to login with password and every fraud user have to know the password (at least) of the user. It is not the case that users from other departments share their passwords, but fraud users just bypasses the need

Re: [ADMIN] Disable TRUST authentication mode

2012-03-10 Thread Jan Lentfer
Am 10.03.2012 16:09, schrieb Jan Lentfer: Sorry, maybe I do not entirely understand what you mean, but just >don't use< trust in you pg_hba.conf? Reading it again, I'd say this is your problem: "The simplest way is >to get the control of the server< and t

Re: [ADMIN] Disable TRUST authentication mode

2012-03-10 Thread Jan Lentfer
Am 10.03.2012 16:00, schrieb c k: Can we disable the trust authentication mode? [...] What steps we can take to prevent such access or to disable the TRUST mode completely? Sorry, maybe I do not entirely understand what you mean, but just >don't use< trust in you pg_hba.conf? Jan -- Se

Re: [ADMIN] check_postgres monitor by Bucardo - any opinions?

2011-10-20 Thread Jan Lentfer
Am 20.10.2011 22:10, schrieb Scott Marlowe: On Thu, Oct 20, 2011 at 12:16 PM, Mark Steben wrote: Hi all, I'm evaluating the check_postgres program. We are running postgres 8.3. Does anybody have any experience with this monitoring software they would like to share? I'm specifically intereste