Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 7119

Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

49 votes
Accepted

ERROR: no schema has been selected to create in

This happens when not having USAGE privilege on any of the schemas of search_path. By default the pseudo-role public (all users) has this privilege on the publicschema, so this error happens only afte …
Daniel Vérité's user avatar
1 vote
Accepted

Loading Custom Rules into unaccent postgresql hosted into an amazon aws instance

In the example CREATE TEXT SEARCH CONFIGURATION fr ( COPY = french ); where the ( COPY = french ) is located? Text search configurations are stored in pg_catalog.pg_ts_config. They can also be …
Daniel Vérité's user avatar
6 votes
Accepted

AWS RDS PostgreSQL dump/restore - syntax error

A pg_dump output with the -Fc (custom) is not a SQL script, it's a compressed archive that only pg_restore is able to handle. You may either pass the dump file to pg_restore and pipe its output to ps …
Daniel Vérité's user avatar
1 vote

Monitoring Amazon RDS with pgtop

I don't know if that applies to Amazon RDS, but a possible reason for getting an empty list of queries with pgtop is when using a version older than 3.7.0 (released in August 2013) against a 9.2 or ne …
Daniel Vérité's user avatar
3 votes
Accepted

Does AWS ever `vacuumlo` PostgreSQL RDS instances?

Probably not, because blindly executing vacuumlo on random databases would be foolish. Unlike vacuum that is pretty much unavoidable on a normal live database, vacuumlo fixes an oversight, a situatio …
Daniel Vérité's user avatar