0
votes
1answer
59 views

Postgresql not listening on the correct port using service command

In my /var/lib/pgsql9/data/postgresql.conf I added port = 55434 and if I start Postgres with /usr/bin/pg_ctl start -D /var/lib/pgsql9/data/ as the postgres user then Postgres is listening to the right ...
-1
votes
1answer
31 views

How to increase the default number of Postgres processes?

Disclaimer: I'm relatively new to Postgres. On my production EC2 DB server, I'm experiencing high CPU usage on two of the five CPUs, ultimately resulting in latency for users of my application. I've ...
0
votes
1answer
69 views

Solutions for a growing Postgresql database on Amazon EC2?

I've been doing a lot of research into scaling issues on Amazon EC2, especially growing databases. I looked into how I can make the database more solid and sound (I use PostgreSQL). Many sources say ...
1
vote
0answers
60 views

How can I store the Postgresql data on the EBS Volumes and not on the Root Volume?

My PostgreSQL database is currently stored in the cloud. Normally, when creating a PostgreSQL database, all the data is stored on the root volume of the EC2 instance. How can I make sure all the ...
0
votes
1answer
84 views

How does data storage on Amazon EC2 work especially for databases?

I've been playing around with Amazon's Web Services for over a year now, however I don't quite understand how it works. When I for example select an AMI of my choice from the EC2 console and I ...
1
vote
1answer
346 views

postgres updated from 9.1 to 9.2, required database update fails

On going from postgres 9.1 to 9.2, it says that the data bases need to be upgraded so on giving the upgrade command I give and get the following $ sudo service postgresql upgrade Stopping postgresql ...
0
votes
1answer
110 views

How to monitor a remote Postgresql Amazon EC2 database through Munin?

How can I monitor a remote postgresql database on Amazon EC2 using Munin? I would like to graph the number of reads, writes, and total database operations.
0
votes
2answers
691 views

Native Postgresql 9.2 Streaming Replication

I'm trying to build up native postgresql 9.2 streaming replication in the Amazon cloud. According to documentation, I've set up everything correctly - but at the slave I get these logs: 2013-02-04 ...
1
vote
0answers
331 views

security group not allowing connection to postgres ec2 aws

Hey im having some trouble allow remote connections to postgres from other ec2 instances using the named security group feature to rules. I have set the listens directive in postgres.conf to "*" and ...
1
vote
2answers
918 views

How to set up postgresql on EC2 so my data will be backed up and safe?

I am in the process of setting up a very small web-app that I hope to eventually grow into something larger. For now it is a near-zero-budget personal project so I don't have a lot of resources to ...
-1
votes
2answers
124 views

How to load balance when database and application running on same instance in Amazon EC2

I have the situation where I am running my application and Postgresql database on same Ec2 instance. Data of Postgresql gets saved on another EBS Volume different from the Root volume of the instance. ...
0
votes
1answer
153 views

Amazon ELB and use of address / server names across multiple servers

I am setting up Nginx servers behind the ELB. I set up so that api.app.com points to an ELB. I wonder which addresses I should use for remote connections, Nginx settings etc.. 1) For example, in ...
1
vote
4answers
167 views

How can I make an AMI mount the same volume when it initializes?

This is for a database (Postgre) VM, whose data is stored on a separate EBS volume. Can I make it so that the same EBS volume is mounted automatically (this is assuming that no other instance is using ...
1
vote
1answer
121 views

Are there measurable benefits to running XFS on EC2

I am looking at creating a PostgreSQL database image (to run on Amazon EC2) and I have heard good things about XFS. However, since ultimately you are running in a VM, the gain of XFS on EC2 might ...
2
votes
1answer
221 views

How to upgrade PostgreSQL on EC2?

I have an Amazon EC2 instance running PostgreSQL 9.1. I am pointing to the RedHat repo for PostgreSQL. Now that 9.2 is out, how do I upgrade? This is new to me.
0
votes
1answer
258 views

Connecting to a Postgres EC2 database

I am trying to connect to a database hosted on AMAZON EC2: ec2-xx-xx-xxx-xxx.xxxx-1.amazonaws.com/companyName I have been given the user and password for this. What is the best way to connect to a ...
2
votes
1answer
310 views

Web server (IIS) and database mirroring (Postgresql)

Recently our web-server crashed and we had to recover everything from a backup which took the whole day(totally unacceptable in our business). So my question is, how can I create a complete mirror ...
1
vote
2answers
206 views

backing up postgres on ec2

Ok, I'm quite new to this server administration stuff. I have set up an ec2 instance running my website. I'm running everything on a single machine - node.js & postgres. What is the best way to ...
3
votes
3answers
5k views

Configure BIND with database backend and DLZ support

Decided to move my windows based DNS servers to linux. The problem is I need to be able to dynamically update zone files without having to restart bind. It seems the most popular solution is to ...
0
votes
2answers
94 views

Compiled PostgreSQL 9.0.2 on Amazon EC2 has no service or startup script

I built postgresql on EC2 and it is running fine. However, I have been manually controlling it from 'pg_ctl start/stop' as there seems to have been no service configured or evident way to configure ...
3
votes
1answer
942 views

PostgreSQL EC2 Backup Strategy

I'm trying to determine the best approach to backing up a PostgreSQL database on Amazon EC2. I've read about a couple of options. 1) Take a daily snapshot of the EBS volume your database is using. ...
0
votes
1answer
434 views

PostgreSQL 9.0 and PHP on Amazon EC2

How can I enable PostgreSQL 9.0 support in PHP on my Amazon EC2 instance? I'm running the free 32 bit Linux Micro instance. I've installed PostgreSQL 9.0 by following these instructions ...
1
vote
3answers
524 views

amazon ec2 beanstalk trying to connect to postgres, unknowns ips

I have a beanstalk server that is trying to connect to a postgres db running on a ec2 machine. The ips are unknown as they always change. What kind of security should I allow for the db? Normally you ...
0
votes
1answer
309 views

how do I install scripts like pg_lsclusters on a Amazon AWS Linux AMI

I am used to debian/ubuntu distros and now trying to experiment with the official Amazon AWS Linux AMI. I have installed postgresql-server, postgresql-devel, postgresql-contrib yum packages. The ...
4
votes
7answers
1k views

Linux freezes every few seconds

We're having an issue where one our Linux boxes (Ubuntu 10.04 LTS, running on EC2 with a quadruple-large size, 68GB of RAM and 8 virtual cores with 3.25GHz each) freezes up every few seconds. Typing ...
5
votes
1answer
845 views

Postgres suddenly slower and higher CPU usage

We're running a Postgres DB that's about 38GB, hosted on a 68GB EC2 instance. It's been humming along, with load at ~0.7 (on an 8 core machine) and little CPU usage until about 16 hours ago, when CPU ...
2
votes
3answers
1k views

Amazon Auto Scaling + Elastic Load Balancer + Web Application

Let's say I have web application that runs on a single EC2 instance (PHP + PostgreSQL). Now I create Load Balancer and set Auto Scaling. The question is: how do I replicate database on the fly when ...
0
votes
2answers
148 views

Diagnosing/logging possible connection permission problem in Postgresql

I've got a J2EE application (Tomcat) which uses Postgresql as the database. This app works fine in development but is failing when I try it on my staging environment. I suspect I've got some kind of ...