[ADMIN] pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

2012-10-19 Thread Lonni J Friedman
Greetings, I'm in the process of planning for a production upgrade from 9.1.6 to 9.2.x (all Linux-x86-64). In my staging environment (which has the same versions), I kicked off pg_upgrade about 5 hours ago, and its still not done. It is making progress, so I don't think anything has gone wrong, b

Re: [ADMIN] Auto Vacuum

2012-10-19 Thread Scott Marlowe
On Fri, Oct 19, 2012 at 11:49 AM, Scott Marlowe wrote: > On Thu, Oct 18, 2012 at 2:13 AM, teyking2003 wrote: >> Can anyone provide me a sample of auto vacuum and also step by step to >> configure it inside my linux ubuntu server? > > Here's the basic instructions on autovacuum for pgsql 8.2. Not

[ADMIN] Streaming Replication (Master Delta Sync)

2012-10-19 Thread Parkirat Bagga
Hi We are using streaming replication for c++ Postgres-9.1 server. We have setup 1 master and 1 slave and streaming replication is working fine. On checking the x-log status for both master and slave, we observed that the master is quite ahead of the slave all the time. Now we have 2 questions

Re: [ADMIN] User creation

2012-10-19 Thread Scott Marlowe
On Fri, Oct 19, 2012 at 1:14 AM, Shams Khan wrote: > Hi Experts, > > I am new to postgresql, just wanted to know more about user creation. > > I tried to create users using command [create user sam] without any option] > what are the default rights given to the user? > > radius=> select * from pg_

Re: [ADMIN] Auto Vacuum

2012-10-19 Thread Scott Marlowe
On Thu, Oct 18, 2012 at 2:13 AM, teyking2003 wrote: > Can anyone provide me a sample of auto vacuum and also step by step to > configure it inside my linux ubuntu server? Here's the basic instructions on autovacuum for pgsql 8.2. Note that since it's out of support, if you run into any bugs or p

[ADMIN] User creation

2012-10-19 Thread Shams Khan
Hi Experts, I am new to postgresql, just wanted to know more about user creation. I tried to create users using command [create user sam] without any option] what are the default rights given to the user? radius=> select * from pg_user; usename | usesysid | usecreatedb | usesuper | usecatupd |

Re: [ADMIN] Database in psql

2012-10-19 Thread Scott Marlowe
On Thu, Oct 18, 2012 at 2:03 AM, teyking2003 wrote: > i'm a very fresh on psql+linux setup. > at my side, i have linux ubuntu 2.6.22-14 server + psql 8.2.5+bluedragon web > server. im confuse with vacuum steps, normally i use You really should look at updating to a later version of pgsql, and ubu

[ADMIN] Auto Vacuum

2012-10-19 Thread teyking2003
Can anyone provide me a sample of auto vacuum and also step by step to configure it inside my linux ubuntu server? thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/Auto-Vacuum-tp5728770.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -

[ADMIN] Database in psql

2012-10-19 Thread teyking2003
i'm a very fresh on psql+linux setup. at my side, i have linux ubuntu 2.6.22-14 server + psql 8.2.5+bluedragon web server. im confuse with vacuum steps, normally i use *psql database_name database_name=# vacuum;/vacuum full/ vacuum full analyst* to perform basic maintenance to the system. but the

Re: [ADMIN] Database in psql

2012-10-19 Thread teyking2003
hi any expert here -- View this message in context: http://postgresql.1045698.n5.nabble.com/Database-in-psql-tp5728767p5728962.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your s

[ADMIN] Stripe width size?

2012-10-19 Thread Jakov Sosic
Hi. What stripe width size are you recommending for postgresql 9.2? Default settings are often 128k, is that OK, or should I go 8k? And what is the best practice with filesystem, to align it to stripe width + stripe unit size, or performance doesn't benefit from it at all? Thank you :) -- Se

[ADMIN] WAL corruption while replication

2012-10-19 Thread Parkirat Bagga
Hi, How to recover, if master postgres WAL got corrupted before it is applied to the standby server? Will I loose all the data present in the WAL segment? How can I partially apply the WAL? Regards, Parkirat Singh Bagga. -- View this message in context: http://postgresql.1045698.n5.nabble.c

[ADMIN] Postgresql switch over process

2012-10-19 Thread Shams Khan
Can somebody tell me how we can automate the switch over process, I know there is once file recovery.conf which contains the parameter trigger_file. But my question is what code that file containsHope my thinking is correct. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) T

[ADMIN] Cannot close 'an error has occurred' dialogue box

2012-10-19 Thread Adrian Heath
Running pgAdminIII v1.14.2 on Debian Wheezy 64bit in KDE4 against a (remote) Debian postgreSql v9.1.6 database (default install) I connect to the server, select Server Status option and the server status window opens. The server status screen lists the current connections and then displays a

[ADMIN] Streaming Replication Server Crash

2012-10-19 Thread raghu ram
Hi All, We have configured Streaming Replication b/w Primary and Standby server and Pgpool-II load balancing module diverting SELECT statements to Standby server. As per our observations, Standby server crashed during peak hours on today and error message as follows: 2012-10-19 12:26:43 IST [119