similar to: block level changes at the file system level?

Il 18/09/2018 17:14, Gordon Messmer ha scritto: > On 9/17/18 11:38 PM, Alessandro Baggi wrote: >> Il 17/09/2018 22:12, Gordon Messmer ha scritto: >>> That doesn'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)

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

I'm having a server report a high load average when backing up Postgres database files to an external USB drive. This is driving my loadbalancers all out of kilter and causing a large volume of network monitor alerts. I have a 1TB USB drive plugged into a USB2 port that I use to back up the production drives (which are SCSI). It's working fine, but while doing backups (hourly) the

Il 17/09/2018 22:12, Gordon Messmer ha scritto: > On 9/17/18 7:50 AM, Alessandro Baggi wrote: >> Running a backup I follow this steps: >> >> 1) Stop httpd >> 2) Create lvm snapshot on the dataset >> 3) Backup database >> 4) restart httpd (to avoid more downtime) >> 5) mount the snapshot and execute backup >> 6) umount and remove the snapshot

I am using RStudio Version1.0.143 on a Windows 7 machine. R version 3.4.0 I am trying to connect to a postgreSQL database with the following command, but I receive an error message that says my password is incorrect. Since I saved my password 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

On Thu, June 9, 2016 1:14 pm, John R Pierce wrote: > where Rsync falls down, is if you need a point in time snapshot... Rsync > processes one file at a time, so if the files are being updated while > its running, the differnet files will be copied at different times. > This is usually fine for static archives of files and such, but > unsuitable for a database server where random

I've a small system that I use to support a number of churches. I provide web and email for them. My current server is running CentOS 6.3 with paired 1TB drives in a RAID1 configuration. It works well. One filesystem is very large, >500GB, and contains numerous large files: SQL, docs, church libraries in ebook and digital form, plus stored videos of church services. My problem is that

Not sure if that is the correct terminology. I have an rsync setup of files between two Windows servers using cwRsync, which uses -apv options among --progress and --delete options. One part of the backup is to transfer a MSSQL backup file and I notice that after the initial transfer taking 20 minutes or more, subsequent daily transfers after is changes each night take only a minute or two max and

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

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

On 6/9/2016 11:43 AM, Valeri Galtsev wrote: > When databases are concerned, I would never rely on a snapshot of their > storage files. Either stop relevant daemon(s), then do fs snapshot, or > better though do dbdump and restore databases from dump when you need to > restore it. Also: databases usually have "hold transactions" flag or > similar, post this flag before

On Wed, 2018-09-19 at 08:55 +0200, Alessandro Baggi wrote: > Il 18/09/2018 17:14, Gordon Messmer ha scritto: > > On 9/17/18 11:38 PM, Alessandro Baggi wrote: > > > Il 17/09/2018 22:12, Gordon Messmer ha scritto: > > > > That doesn't look right.? It should look more like 1) stop or > > > > freeze? > > > > all of the services (httpd and

> -----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

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

On 9/17/18 11:38 PM, Alessandro Baggi wrote: > Il 17/09/2018 22:12, Gordon Messmer ha scritto: >> That doesn'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

Hi, can someone tell me whether applications can expect the write requests they make to be executed in order? For instance, suppose an application requests that a file be deleted, and then that another file be moved to an unrelated place. Will these events always happen in that order? Or to put it another way, if something unexpected happens in the meantime (say the computer crashes), is it

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,

Samba friends, I work in Wal-Mart's IT department, specifically with Unix Servers of various flavors, but HP-UX is predominant in our Home Office environment. I recently built an two node HA cluster on HP 11.11 boxes. I want to be able to have Samba use the virtual name of my cluster. Currently Samba is configured to use the hardcoded box name, however if the box happens to go down, we

Thanks in advance. I have a vector of numbers which contain sections that are sequences which increase by a value of 1 followed by a gap in the data and then another sequence occurs, etc: x<-c(1:3, 6: 7, 10:13) From the vector I need to extract 2 items of information A) the first number in the sequence (e.g., 1, 6, 10) and B) how many observations were in each sequence section (e.g., 3,

Il 07/05/2015 11:24, Marcin Trendota ha scritto: > W dniu 06.05.2015 o 21:21, Alessandro Baggi pisze: > >> What do you mean about Backup PC? >> Any experiences? >> What solution do you use? > > BackupPC is good, howewer it's a pity you can't search for a file in > GUI. But it works well, i'm backing up 32 hosts (servers, desktops). > > Can