Re: [ADMIN] How to setup PostgreSQL using Windows Authentication?

2012-06-12 Thread Magnus Hagander
On Jun 13, 2012 4:21 AM, "Craig Ringer" wrote: > > On 06/13/2012 02:37 AM, Peter Cheung wrote: >> >> According to http://www.postgresql.org/docs/9.1/static/auth-methods.html, SSPI only works when GSSAPI is available and GSSAPI support has to be enabled when PostgreSQL is built. Does it mean that

Re: [ADMIN] How to setup PostgreSQL using Windows Authentication?

2012-06-12 Thread Craig Ringer
On 06/13/2012 02:37 AM, Peter Cheung wrote: According to http://www.postgresql.org/docs/9.1/static/auth-methods.html, SSPI only works when GSSAPI is available and GSSAPI support has to be enabled when PostgreSQL is built. Does it mean that I need to uninstall PostgreSQL and reinstall it wi

Re: [ADMIN] Merging two databases

2012-06-12 Thread Craig Ringer
On 06/12/2012 06:23 PM, Lukasz Brodziak wrote: Hi there, Is there a way of merging two databases in postgresql in the way of differential replication? The thing is that we have two DBs with same schemas and we want to merge the data within them into one single replica. Are there any tools/ways o

[ADMIN] How to install Postgresql with GSSAPI support using One click installer?

2012-06-12 Thread Peter Cheung
Hi, I have installed Postgresql using One click installer on a Windows Server. How can I check whether GSSAPI support is enabled so I can use SSPI for Windows Authentication? Thanks.

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-12 Thread Magnus Hagander
On Tue, Jun 12, 2012 at 8:37 PM, Lonni J Friedman wrote: > On Tue, Jun 12, 2012 at 10:49 AM, Fujii Masao wrote: >> On Tue, Jun 12, 2012 at 2:37 AM, Lonni J Friedman wrote: >>> On Fri, Jun 8, 2012 at 7:29 PM, Fujii Masao wrote: On Sat, Jun 9, 2012 at 4:30 AM, Lonni J Friedman wrote:

Re: [ADMIN] How to setup PostgreSQL using Windows Authentication?

2012-06-12 Thread Peter Cheung
According to http://www.postgresql.org/docs/9.1/static/auth-methods.html, SSPI only works when GSSAPI is available and GSSAPI support has to be enabled when PostgreSQL is built. Does it mean that I need to uninstall PostgreSQL and reinstall it with GSSAPI support? I used the One click install

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-12 Thread Lonni J Friedman
On Tue, Jun 12, 2012 at 10:49 AM, Fujii Masao wrote: > On Tue, Jun 12, 2012 at 2:37 AM, Lonni J Friedman wrote: >> On Fri, Jun 8, 2012 at 7:29 PM, Fujii Masao wrote: >>> On Sat, Jun 9, 2012 at 4:30 AM, Lonni J Friedman wrote: On Thu, Jun 7, 2012 at 11:04 PM, Craig Ringer wrote:

[ADMIN] Hot backup for postgres 8.4

2012-06-12 Thread Amador Alvarez
Hi there, I have been looking for a good solution to backup a postgresql 8.4 database server (not pg_dump) and the only options that it seems that I have are either a Omnipitr or a custom-coded solution. I am a little bit afraid about setting up omipitr in production for archiving & backup, e

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-12 Thread Fujii Masao
On Tue, Jun 12, 2012 at 2:37 AM, Lonni J Friedman wrote: > On Fri, Jun 8, 2012 at 7:29 PM, Fujii Masao wrote: >> On Sat, Jun 9, 2012 at 4:30 AM, Lonni J Friedman wrote: >>> On Thu, Jun 7, 2012 at 11:04 PM, Craig Ringer wrote: On 06/08/2012 09:01 AM, Lonni J Friedman wrote: > > On T

Re: [ADMIN] Why auto vacuum almost running all the time on one toast table?

2012-06-12 Thread Tom Lane
Rural Hunter writes: > v9.1.3 on Ubuntu 10.04 server. I have one table which has frequent > insert and weekly deletion, no update. Recently, I found the auto vacuum > on the toast table of it almost running all the time. each run took > around 1 hour. I don't think there are so many inerts so t

Re: [ADMIN] could not rename temporary statistics file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or directory

2012-06-12 Thread Magnus Hagander
On Thu, Jun 7, 2012 at 8:01 PM, Fabricio wrote: > Hi. > > I have this problem: > > I have PostgreSQL 9.1.3 and the last night crash it. > > This was the first error after an autovacuum (the night before last): > > <2012-06-06 00:59:07 MDT    814 4fceffbb.32e >LOG:  autovacuum: found orphan > temp

[ADMIN] Merging two databases

2012-06-12 Thread Lukasz Brodziak
Hi there, Is there a way of merging two databases in postgresql in the way of differential replication? The thing is that we have two DBs with same schemas and we want to merge the data within them into one single replica. Are there any tools/ways of doing this? Of course when the merged db is cre

Re: [ADMIN] How to setup PostgreSQL using Windows Authentication?

2012-06-12 Thread Craig Ringer
On 06/12/2012 10:00 AM, Peter Cheung wrote: Hi, I'm new to PostgreSQL. I installed PostgreSQL on a Windows Server 2008 R2 server. I have created a database and an user in Windows Active Directory. How can I configure that user to access that database? By default, Windows users and Pos

[ADMIN] Why auto vacuum almost running all the time on one toast table?

2012-06-12 Thread Rural Hunter
v9.1.3 on Ubuntu 10.04 server. I have one table which has frequent insert and weekly deletion, no update. Recently, I found the auto vacuum on the toast table of it almost running all the time. each run took around 1 hour. I don't think there are so many inerts so that it reaches the auto vacuu