search for: pg_dump

...ore like 1) stop or freeze >>> all of the services (httpd and database), 2) make the snapshot, 3) >>> start or thaw all of the services, 4) mount the snapshot, 5) back up >>> the data, 6) remove the snapshot. >> >> About database setup I perform backups via pg_dump so how the snapshot >> affects pgsql database? What your suggestion I must perform database >> backup copying only filesystem file and not pgsql.sql database dump? > > > If you want a plain-text dump of the DB, you can do that before the LVM > snapshot sequence: 1) pg_d...

Hi, I'm trying to move a postgres database to another server and I ran into some weird problems. Pg_dump command was not giving any output and the logs got filled with some SELinux errors. So I turned off SELinux completely (and rebooted). Now I'm getting the following error message: # pg_dump -U postgres database > database.out pg_dump: SQL command failed pg_dump: Error message from server: E...

...#39;t look right.? It should look more like 1) stop or freeze all > of the services (httpd and database), 2) make the snapshot, 3) start or > thaw all of the services, 4) mount the snapshot, 5) back up the data, 6) > remove the snapshot. > About database setup I perform backups via pg_dump so how the snapshot affects pgsql database? What your suggestion I must perform database backup copying only filesystem file and not pgsql.sql database dump? > Your sequence makes changes (step 3) after the snapshot is taken.? In > that case, the backup that you made will not be a part of...

...and database), 2) make the snapshot, > > > > 3)? > > > > start or thaw all of the services, 4) mount the snapshot, 5) > > > > back up? > > > > the data, 6) remove the snapshot. > > > > > > About database setup I perform backups via pg_dump so how the > > > snapshot? > > > affects pgsql database? What your suggestion I must perform > > > database? > > > backup copying only filesystem file and not pgsql.sql database > > > dump? > > > > > > If you want a plain-text dump of...

...-----Original Message----- > From: centos-bounces at centos.org [mailto:centos-bounces at centos.org] On > Behalf Of Andy Masiar > Sent: Thursday, April 28, 2005 2:41 PM > To: centos at centos.org > Subject: [CentOS] relation "pg_user" does not exist error when > runningpg_dump > > Hi, > > I'm trying to move a postgres database to another server and I ran > into some weird problems. Pg_dump command was not giving any output > and the logs got filled with some SELinux errors. So I turned off > SELinux completely (and rebooted). Now I'm gettin...

I'm trying to streamline a backup system using ZFS. In our situation, we're writing pg_dump files repeatedly, each file being highly similar to the previous file. Is there a file system (EG: ext4? xfs?) that, when re-writing a similar file, will write only the changed blocks and not rewrite the entire file to a new set of blocks? Assume that we're writing a 500 MB file with only 1...

I have a weird problem with creating a new record when using PostgreSQL. From inside script/console ... >> entity = Entity.new >> entity.first_name = "Foo" >> entity.last_name = "bar" >> entity.save Throws an exception due to the following SQL error: duplicate key violates unique constraint. The application was working fine before and suddenly

...t.? It should look more like 1) stop or freeze >> all of the services (httpd and database), 2) make the snapshot, 3) >> start or thaw all of the services, 4) mount the snapshot, 5) back up >> the data, 6) remove the snapshot. > > About database setup I perform backups via pg_dump so how the snapshot > affects pgsql database? What your suggestion I must perform database > backup copying only filesystem file and not pgsql.sql database dump? If you want a plain-text dump of the DB, you can do that before the LVM snapshot sequence: 1) pg_dump, 2) stop or freeze all o...

...oots up from the normal 0.5 - 1.5 or so up to a high between 10 and 30. Strangely, even though the "load is high" the server is completely responsive, even the USB drives being accessed are! Backup script is really simple, run via cron, pretty much just: #! /bin/sh hour=`date +%k`; pg_dump <options> mydatabase > /media/backups/mydatabase.$hour.pgsql; where /media/backups is the mount point for the USB drive. Using top to diagnose, nothing seems to be particularly high! IoWait seems reasonable (10-30%) and CPUs are 0.5%, Idle is 70-90%. Even accessing the USB partition...

Hi all. I am using PostgreSQL in my current project and I have couple of questions on this topic. Previously I have used 3 databases for project. i.e. megaproject_development, megaproject_test and megaproject_development. But I don''t like this variant because of ''rake dump_db_structure'' writes a lot of PostgreSQL specific data for structure file (operators, functions,

...in a file, I think I remember it. I searched for a solution online, but cannot figure out what to do. If I have to change my password, please provide explicit instructions. > con <- DBI::dbConnect(RPostgreSQL::PostgreSQL(), + password = "sql1", + port = 5432, + dbname = "pg_dump-sfpg-2017-08-18" + ) Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (could not connect Ira at localhost:5432 on dbname "pg_dump-sfpg-2017-08-18": FATAL:password authentication failed for user "Ira" ) Thanks. Ira [[alternative HTML version deleted]]

...synchronization' that only refreshes the file contents? This is a binary file and I did not know this was possible. I've been running rsync between unix/linux boxes for years doing backup and would love this to work with our PostgreSQL backups. I've tried the same options and choosing pg_dump format options of both 'c' and 'p' (plain text), but nothing works. It always transfers the entire file. I'm I seeing this correctly that rsync can do this? If so, what are the requirements to make it happen? Thanks for the help... -- Robert

http://dev.rubyonrails.com/changeset/856 looks to me like it''s not going to work, since there''s no way of specifying a password to pg_dump/dropdb/createdb. If you set PGPASSWORD in your environment it might work, but that''s not documented anywhere and isn''t done automatically in the Rakefile. See http://thread.gmane.org/gmane.comp.lang.ruby.rails/3693 for the discussion we had a couple of weeks back about this....

Dear all, I am implementing a backup system, where thousands of postgreSQL databases (max 1 Gb in size) on as much clients need to be backed up nightly across ISDN lines. Because of the limited bandwidth, rsync is the prime candidate of course. Potential problems I see are server load (I/O and CPU), and filesystem limits. Does anyone have experience with such setups? Ron Arts -- NeoNova BV

Folks, I don''t like that I have to grant CREATEDB rights to the test user to get testing working smoothly with Postgres. What is the philosophical reason that Rails wants to drop and recreate databases during the testing? It would seem to me that "pg_dump -c" (the "clean" dump option, similar to mysqldump''s --add-drop-tables ) would suffice when you''re using SQL format schema dumps. Another problem with dropping databases is that procedural languages are lost unless they are loaded into template1. The workaround is...

Hello, I have tried to install the salted hash login generator by following the quick start guide at: http://wiki.rubyonrails.com/rails/pages/SaltedLoginGeneratorQuickstart. Everything seems to work fine until I try to run the unit tests by doing ''rake test_units'', then I get the following error message: <error-message> [brasse@keso login-test]$ rake test_units (in

Hi list, I've a bacula system based on disk volume that I need to refresh (new install). There is a way to mantain the "current status" (volumes, catalog and other if needed) when migrating the system to a new installation? Thanks in advance

...all? Another question is about Catalog backup. When I need to restore a backup, bacula reads catalog and performs restore if possibile. When a backup is perfomed, all info are saved on catalog. From many how-to I found that people make ct backup directly from bacula client and not from script (pg_dump...). Then today I follow this method because seems to be the most valid. Why? What method is better? Can I restore a catalog backup without bacula installed? Can I restore a catalog backup with bacula installed but without a valid catalog imported? I hope I was clear. Thanks in advance. Il 02/...

...; dump. I usually use combination: I do dbdump, and back up these dump files > on regular backup schedule (and exclude db files from backup). for postgresql, you can use rsync style copies of the file system if you bracket the rsync in pg_start_backup(); and pg_stop_backup() calls. dumps (pg_dump) are fine for smaller databases, but become really unwieldy for very large ones, and a straight database file system copy like rsync is required to initialize a streaming replication slave (although this can be done with the pg_basebackup command line util, there's times when doing it manua...

Hello! I''ve submitted a patch to work around a problem when multiple schemas are included in the search_path in database.yml for PostgreSQL databases. (Long story short: the pg_dump --schema flag only accepts a single schema.) http://dev.rubyonrails.org/ticket/6665 While I''ve tested the regex pattern used to check for multiple schemas, I''m unsure of how to properly write tests to be included in the standard Rails test suite. Any advice would be apprec...