similar to: Connect to postgreSQL

On Sat, 26 Aug 2017 18:35:31 -0700 Ira Sharenow via R-help <r-help at r-project.org> wrote: Can you access the postgres database through psql or some other route? Also, do you require a password to access the database from these alternatives? JWDougherty

I am getting a-mail with security run output from one of my 9.2-RELEASE servers whose primary role is mysql server: sql1.kappastar.com login failures: Nov 18 02:11:09 sql1 sshd[58619]: Invalid user this-is-not-an-attack from 188.95.234.6 Nov 18 02:11:17 sql1 sshd[58621]: Invalid user this-is-not-an-attack from 188.95.234.6 Nov 18 04:54:10 sql1 sshd [59190]: reverse mapping checking getaddrinfo

Hi. I am new to R and facing a problem that I cannot solve. I am writing some basic functions. Then I would like to have a master function that allows me to call one of the functions which I created, but I cannot figure out how to do so. Below is an example. The functions rnormIra and runifIra both seem to work fine. I do not get an error message when entering the definition of the master

Hi, May be you can try this: obj_name<- load("arun.RData") Pred1<- get(obj_name[1]) Actual1<- get(obj_name[2]) library(reshape2) dat<-cbind(melt(Pred1,id.vars="S1"),value2=melt(Actual1,id.vars="S1")[,3])? # to reshape to long form colnames(dat)[3:4]<- c("Predict","Actual") dat$variable<- as.character(dat$variable) #not that

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

Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new

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

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)

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, I'm having trouble connecting to my postgreSQL db on Heroku(Amazon) using RPostgreSQL. I've looked through GitHub for people doing the same thing. There are quite a few examples and all look similar to the below: drv <- dbDriver("PostgreSQL") con <- dbConnect( drv, dbname = "dadqn30er7ghpl", host =

Hi all, I''m stuck with a peculiar problem. I have CentOS 5.5 and Xen. I have numerous Windows 2003 guests and never had this problem. An application requires SQL server 2008 which is requiring Windows Server 2008. I downloaded the 2.8 Gig install DVD ISO. I create a new guest and connect the ISO as hdc. The system starts and says "Starting Windows" but hangs and no

Can someone point me to an implementation of the "runs up and runs down" test, or does such beast exist in R? From web searches the "runs up and runs down" test is commonly used for testing pseudo-random number generators and in simulations. John C. Davis describes its use in geology in his book on geological statistics (2002). Having searched the full site, I can locate only

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

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

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

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

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

Is anyone else encountering trouble viewing the basic www.r-project.org page? Or has it been changed recently so that google hasn't kept up? I find I can access the mirror of the CRAN page at http://www.maths.bris.ac.uk/R/, none of the *.org pages. Nor can I jump to the R homepage from the CRAN mirror. JWDougherty