Tag Info

New answers tagged


wal-e backup push will NOT push any wal files to s3. So this backup will be mostly unrecoverable. Use archive_command = '... wal-e wal-push %p' on master to make this backup usable.


If I were setting up a new server, I wouldn't use anything below 9.3.6. There have been many improvements since 9.1. And if you use 9.4.1, there is some code to let it use larger amounts of RAM for index creation than it previously could. Neither of the parameters you listed are particularly important for creating indexes. The most critical for that ...


http://www.postgresql.org/docs/9.1/static/installation-platform-notes.html See section Looks like you can import bash into plpgsql. I know SQL or ingres sql is compatible with unix. Can't find anything to suggest that plpgsql is. HTH


I managed to resolve this issue as follow (2nd considered solution - revisited): All in a while cicle, for every file: select file_id , file_version, oid and put them in 3 variables perform a [lo_export] of pg_largeobjects that require oid a path+filename to be defined. The filename will be the concatenation of the file_id and file_version. during ...


By default PostgreSQL logs to stderr, from PostgreSQL Documentation 18.8. Error Reporting and Logging: PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set this parameter to a list of desired log destinations separated by commas. The default is to log to stderr ...

Top 50 recent answers are included