Tag Info

New answers tagged

0

There are three parts in the output: could not change directory to "/root": Permission denied: your 'sudo' succeeds but your postgres user fails to access the home of root. You may check for the setting of homedirectory for postgres in /etc/passwd. The files belonging to this database system will be owned by user "postgres". This user must also own the ...


0

I looked into auto failover, using repmgr, a few months back. It seems repmgr is working as expected. IIRC repmgr doesn't bring an old master up as a new standby, you would need to run a "--force standby clone". You can set other standby nodes to follow a new master, should failover occur (repmgr standby follow). Would you expect your master to recover ...


3

Personally, I'd just remount whatever you've stuck at /database onto /var/lib/postgresql, because you're going to confuse the living heck out of anyone who has to deal with this frankenmachine in the future. That being said, if you really want to move it, there's two ways forward: Make /var/lib/postgresql a symlink to /database. Keeps the filesystem ...


2

You will not be able to install any additional software on an Amazon RDS instance, because RDS is offered as a "software-as-a-service" (SaaS) platform. With most/all SaaS offerings, you only get access to an endpoint and a limited set of configuration variables, and are not given access to the underlying architecture (e.g. OS, networking, hardware). If you ...


0

I use autopgsqlbackup (PostgreSQL port of automysqlbackup), also installable as Debian package.


0

I was getting this kind of error when my pg_hba.conf or AWS security groups have not been configured properly. There are plenty of docs about how to resolve this. For example, you can check this list link


0

When you trying to backup all database it worth using pg_dumpall, as for specific database backup - I don't have any issue when I do in the following way: Create dump - pg_dump -o -h <host> -U roleName -d dbName -n "\"SCHEMA\"" > schema_name.dump Change owner globally in dump file (for small size) vi schema_name.dump then ...


0

This could be because pgpool sees this query as read-only, but since it's actually calling a function (which may contain INSERT UPDATE or DELETE statements) it breaks while connecting to the read-only server.


0

This sounds like it could easily be checkpoint activity, yes. Configure PostgreSQL to do spread checkpoints. See: http://www.postgresql.org/docs/current/static/wal-configuration.html http://www.postgresql.org/docs/current/static/runtime-config-wal.html#GUC-CHECKPOINT-COMPLETION-TARGET Make sure that checkpoint_segments is high enough for your workload ...


1

Slony is trigger based, and highly configurable. Yes - according to the documentation here . DDL changes can be applied directly on a node through an application such as psql. The DDL changes will not be replicated by Slony-I and therefore must be manually applied to every relevant node. The following points should be kept in mind when applying DDL ...


1

I made this SQL to show the tables vs disk hits ratio: -- perform a "select pg_stat_reset();" when you want to reset counter statistics with all_tables as ( SELECT * FROM ( SELECT 'all'::text as table_name, sum( (coalesce(heap_blks_read,0) + coalesce(idx_blks_read,0) + coalesce(toast_blks_read,0) + coalesce(tidx_blks_read,0)) ) as ...


1

You are out of storage where pg_stat_tmp/pgstat.tmp resides. Which is exactly what the error message tells you.


1

It looks like the original dump has something really weird in it. There must be something like a CREATE TABLE pg_catalog.attachments statement in the dump. This shouldn't be possible, since you can't create tables in pg_catalog unless the debug option allow_system_table_mods is on. The only other way I can imagine this happening is if, somehow, the ...


0

I run a fairly large owncloud install (company) and recommend MariaDB since its MySQL, which is basically the defacto standard for relational databases for many many many years across many many many applications. Unless you are doing something INSANE with owncloud, MariaDB will never be the performance limiting factor. And even if it was, you can size it ...


2

The OwnCloud performance tuning documentation recommends using MySQL/MariaDB. There are some people using PostgreSQL, including some core developers, but your installation will be more prone to errors and various problems if you use it.


2

This sounds like you have corruption of some sort on your filesystem or disk. I'd recommend looking here: postgresql corruption Following that, I'd look in dmesg or /var/log/messages for any hardware errors you might see. If you got a working dump, I'd copy the current data directory away from /var/lib/postgresql/8.4/main, run pg_createcluster 8.4 main ...


-1

Please use this script for generating backup. PGPASSWORD='database password' PGUSER='database user' PGHOST='localhost' PGPORT='psql portno' PGDATABASE='database name' pg_dump -Ft <database name> -x -O -f '<backup file name.tar>'


1

Being confronted with the very same issue, I did a few ours of Google-Foo to get to the root of the issue: As Gabriel assumed correcty in his answer, it's not the fault of Roundcube – but of the way the password is stored and the encryption works. Few obvious basics When talking about CRAM-MD5, MD5, or CRYPT, we're talking about one-way-encryption: A hash ...


0

You can also start and stop postgres server without specifying version: /etc/init.d/postgresql start start - to start server stop - to stop server status - to know status, whether server is running or not


0

Able to take backup of a table on a different schema in PostgreSQL with the following command and its working perfectly: pg_dump -U postgres -t 1.activity -d geopostgrest -f activity_05-08-2015.sql


0

Can you try with -n 1 (space between them)? Also I cannot find the -d parameter. If you need to specify the database then you just put it in as the last or first parameter.



Top 50 recent answers are included