Amazon RDS (postgres) connection limit?

amazon-rds
cs44 picture cs44 · Nov 20, 2013 · Viewed 59.2k times · Source

I've searched the web and browsed the RDS docs, yet I can't seem to find an open connection limit.

For what it's worth, I'm planning on using the new Postgres flavor of RDS, but I suppose an answer from the mySQL side of the house would be acceptable as well.

Thanks!

Answer

sskates picture sskates · Dec 10, 2013

If you setup a PostgreSQL RDS instance you can query for max_connections:

select * from pg_settings where name='max_connections';

max_connections is set to 5696.

Related questions

how to run command "mysqladmin flush-hosts" on Amazon RDS database Server instance?

I got a database server failure, says host is blocked because of many connection errors. It ask me to unblock with 'mysqladmin flush-hosts' how and where should I run this command to our amazon rds database server? thank you

Read More
Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access …

Read More
MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.…

Read More