similar to: postgres/R access problems

am in a bit of a quandry... I have asked postgresql-users list and haven''t gotten anything to work with... > > How do I change the owner of a schema? > > > > ALTER SCHEMA "public" OWNER to "some_user"; #? > > http://www.postgresql.org/docs/current/interactive/sql-alterschema.html > > The docs explain this very situation. HTML

I''m at a loss to explain why the postgres gem will not work on my new server. I''ve gotten it working on several other servers in the past. The major difference between then and now is that I''m using a newer version of PostgreSQL. 8.x as opposed to 7.x. === Server setup OS: Fedora Core 6 (Commands shown with "$" are performed as the same user that mongrel

Hi, I have the following exec type: exec{"createdb": path => "/usr/bin:/usr/sbin:/bin", command => "sudo -u postgres createdb -U postgres -E UNICODE opennms", unless => "sudo -u postgres psql -l | grep opennms > /dev/null", require => Service["postgresql"], } Where this basically says, if the

(in C:/projects/books/TheatreTickets) ** Invoke db:test:clone_structure (first_time) ** Invoke db:structure:dump (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:structure:dump ** Invoke db:test:purge (first_time) ** Invoke environment ** Execute db:test:purge ** Execute db:test:clone_structure psql:db/development_structure.sql:15: ERROR: language

Hello, When I try to run "rake clone_structure_to_test" on my project, I get the following errors: $ rake clone_structure_to_test (in /home/www/cedscreening) psql:db/development_structure.sql:8: ERROR: permission denied to set session authorization psql:db/development_structure.sql:16: ERROR: permission denied for schema public psql:db/development_structure.sql:34: NOTICE: CREATE

I need to retrieve my asterisk to retrieve a values from postgresql, i am looking for some sort of application like *mysql*() app, I found one but it is only available on Suse, is there any way for doing this? Regards, O.Youssef -------------- next part -------------- An HTML attachment was scrubbed... URL:

hello list, i set up a new rails instance with the new rails 2.0 lib. i installed rails 2.0 over my earlier version of rails where is add postgres support via gem install postgres so the error with postgres appears if i set up the database with rake db:create:all the following message appears: rake aborted! Please install the psql adapter: `gem install activerecord-psql- adapter` (no such file

On 1/22/2016 11:00 AM, Eero Volotinen wrote: > It works on linux, it can't be secure? if you can insert a custom Machine Owner Key into this keyring, then anyone with sufficient ingenuity can, too. which renders the whole signature thing moot, other than as another step to be cracked. -- john r pierce, recycling bits in santa cruz

Hi Firstly apologies but i have to install an app that uses postgres but i am more a MySQL/Oracle guy so i maybe doing something really wrong here.. I am following instructions for creating a DB user and encountering this # createuser -ADP -U postgres foo Enter password for new user: Enter it again: createuser: could not connect to database template1: FATAL: IDENT authentication failed for

ok, so I removed the default postgresql install and installed it from the software collections.. following the instructions at https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/ and I get this [root at home1p /home/jason]$scl enable rh-postgresql95 bash [root at HOME1P jason]# postgresql-setup --initdb * Initializing database in

I am writing a application where there is a lot of data in an old Filemaker program that I am going to need to do a 1 time import...1 main table and 2 related tables. I can get the data from Filemaker into a dbf or csv or Excel file without problem. Is anyone aware of a utility for postgresql or a rails plug-in that might make this easier? I am worried about Rails import since I can''t

Hy all, I apologize for my ingenuity in regard to interfaces in R, but I do need it for my work. In that respect I took a simple and small example from the net (the "hello world", one) to interface R with C. I have a Windows XP OS using R.2.5.0 and in that regard I have installed the Perl and RTools files to my PC. I also wrote a proper path file, as suggested. The C program is:

I'm not sure if this is the best subject line, and I apologize in advanced for the cross-posting, but I've been trying to get past a piece of code for two days now, and seem to have narrowed where a show stopping crash is occurring... I keep getting: psql:../sql/schedpak.sql:257: server closed the connection unexpectedly This probably means the server terminated abnormally before or

FIXME this patch isn't complete, still need to figure out the ldap command to wait for that service, something along the lines of: ldapsearch -b dc=priv,dc=ovirt,dc=org -x (but how will we parse the base from the installer? also this cmd fails, how to fix?) --- installer/modules/ovirt/manifests/ovirt.pp | 8 +++++- installer/modules/ovirt/manifests/postgres.pp | 13 ++++++---

hi friends, i had installed postgres database for call log,call detail. it has restarted succesfully but when i check tcp connection i dont get any welcome message by psql. [root at localhost ~]# # psql -h 127.0.0.1 -U asterisk password [root at localhost ~]# th in advance. -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

Hello List, For a small project I''ve been using ''ruby script/spec -X spec'' to execute my specs. Now that I added ZenTest on it, found that the test takes longer to run due the complete load of test environment. Since autotest uses ''script/spec -O spec/spec.opts'' as the command, I decided to add --drb to spec.opts Using --drb or -X, spec_server is

Hello Guys, I''ll like to suggest a small release fix before we start doing big changes: platform fixes. Current we''re setting MSWIN32 (mswin32) as platform for Windows gem, but we should be using Gem::Platform::CURRENT instead (i386-mswin32 as current Ruby windows implementation). Also, the jruby/java platform need to be defined. That change will ease the compatibility path

Hello, I know in ruby that when you want to find the size of your query say [1,2,3,4,5,6] would provide 6 as the total size, length, or even count. When I try to use size, length, or count on my application, I would get a pretty darn slow performance (takes around 10 seconds to load each count and I do it twice). Is there another faster way to get the total size from the postgres query? I am

I have a shell script (sh) where I create a user and import data to a postgres database <snip> su -c "createuser -A -D -P $PG_user" postgres su -c "psql -d$PG_database -h localhost -U$PG_user -W -f postgresql.sql " postgres </snip> when the script executes those command, it ask for a password, how could I do this without have to enter the passwd, I would like that