Tag Info

New answers tagged

2

I rarely buy RHEL support. I have worked in environments where all systems were fully-paid RHEL and others where thousands of systems were running the license-free CentOS variant. The maintenance and management overhead was slightly higher with paid Red Hat. There was a bit more headache in managing licenses and entitlements and delays in deployment. Again, ...


-2

If you are running a Production application (your business is making money off of it), and you don't have Support, you could be looking at a lot of lost dollars, and your company reputation could fall. Enterprise support for RHEL is very good, and responsive. You know you're ability, but I'm sure you don't know everything, and can't anticipate everything. ...


0

Use http://apt.postgresql.org/ to get releases of PostgreSQL that'll install in parallel with existing installs on Debian and Ubuntu.


1

I ran into this problem today. Looking at nginx error logs, I found that PHP was getting permission denied when trying to write sessions to /var/lib/php5. The solution was to grant write access to this folder for the nginx user (which I had changed from www-data).


0

Autocomplete on column names doesn't work in the SELECT clause, because PostgreSQL doesn't yet know what table you might be talking about. It could offer all functions, aggregates, and all columns across all tables in all schemas, but that'd be pretty slow and not very helpful. Part of the problem is that SQL's syntax is basically backwards. It should ...


0

Per discussion on this Homebrew issue: https://github.com/Homebrew/homebrew/issues/21920 you may just need to do this: export PGDATA=/usr/local/var/postgres Just check and see that the directory does indeed live there and has the postgres configuration files.


1

Why settle down with a daily backup when you can easily have point-in-time recovery with barman?


0

I had the same issue, using PostgreSQL 9.3 on CentOS 6. I deleted the /var/lib/pgsql/9.3/data folder, then re-ran the command sudo service postgresql-9.3 initdb ... which successfully initialised the db service again.


2

This is controlled through the use of "Parameter Group" settings. 1) In the RDS dashboard, go to "Parameter Groups" 2) Create a new parameter group, make sure the "Group Family" is set to postgres9.3, name it whatever 3) Go back to "Parameter Groups", select the newly created group and then "Edit Parameters" 4) Set "rds.log_retention_period" to whatever ...


0

Check to ensure that /var/lib/postgresql/8.4/main/wal_archives exists. You will also want to ensure it's writeable by the postgres user, though if this was a permissions problem the error would be different.


1

Doing some more experimenting, I have found that the cause of our problem was indeed gunicorn's eventlet worker class. Each microthread made it's own persistent connection, and there was no way at all to reuse any of them. Disabling eventlet has made the load on our webservers go up (but not by much), but the postgres load is now down to an average of 3. ...


0

In general it'd best to avoid this sort of multi-question. It's hard to provide a definitive answer to four questions in one, especially with not fully overlapping areas of expertise. Still, best effort: Establishment of TCP socket connections is the same within EC2 as outside it. Everything you do in normal TCP/IP networking you do the same within ETC. ...


1

I highly recommend using a tool for this and not mysqldump In the past I have used https://github.com/philipsoutham/py-mysql2pgsql with great success


2

The "most secure" one will be the DBMS that you and your staff know how to properly operate, maintain, and secure. So, it depends on your skillset.


1

PGDG publishes RHEL 5 packages; see http://yum.postgresql.org/ for instructions. The package name for PostgreSQL in the PGDG repository is different. That prevents postgresql packages from being upgraded with a simple yum update. That is by design, because it'd leave you with a surprise major version upgrade - causing at minimum some significant downtime, ...


1

You can use the yum repository provided by the PostgreSQL project: rpm -hiv http://yum.postgresql.org/9.1/redhat/rhel-5-x86_64/pgdg-redhat91-9.1-5.noarch.rpm or rpm -hiv http://yum.postgresql.org/9.1/redhat/rhel-5-i386/pgdg-redhat91-9.1-5.noarch.rpm That will add their repository for you. See this document for more information.


1

Found the code (Google wasn't revealing it) and it simply doesn't exist. I've raised this as a feature request here and am inspecting the code to see if I can contribute. Salt is amazing but it still has lots of these little gaps. UPDATE: after going through the code you can specify the database with the parameter maintenance_db, which is misleading ...



Top 50 recent answers are included