search for: psql

...oke clone_structure_to_test (first_time) ** Invoke db_structure_dump (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db_structure_dump ** Invoke purge_test_database (first_time) ** Invoke environment ** Execute purge_test_database ** Execute clone_structure_to_test psql:db/development_structure.sql:28: NOTICE: CREATE TABLE will create implicit sequence "case_managers_id_seq" for "serial" column "case_managers.id" psql:db/development_structure.sql:57: NOTICE: CREATE TABLE will create implicit sequence "placements_id_seq" fo...

...ase (first_time) ** Invoke environment ** Execute purge_test_database dropdb: database removal failed: ERROR: database "darkthrone" is being accessed by other users createdb: database creation failed: ERROR: database "darkthrone" already exists ** Execute clone_structure_to_test psql:db/development_structure.sql:13: ERROR: schema "development" already exists psql:db/development_structure.sql:27: ERROR: schema "test" already exists psql:db/development_structure.sql:34: ERROR: language "plpgsql" already exists psql:db/development_structure.sql:45: ER...

...ls 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 to load -- active_record/connection_adapters/ psql_adapter) (See full trace by running task with --trace) i execute the command to install the adapter but there is also an error like this: Updating metadata for 26 gems from http://g...

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 TABLE will create implicit sequence "pages_id_seq" for "seria...

...virt/manifests/postgres.pp +++ b/installer/modules/ovirt/manifests/postgres.pp @@ -45,14 +45,19 @@ class postgres::bundled{ hasstatus => true } + single_exec { "wait_for_postgres" : + command => "/usr/bin/ovirt-wait4service 'psql -l -U postgres' 10 2", + require => Service[postgresql] + } + single_exec {"create_ovirt_db": command => "/usr/bin/createdb ovirt -U postgres", - require => [Exec[postgres_add_all_trust], Service[postgresql]] + require =>...

...ission denied Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) But if I use psql and connects to the same db server with the same username and password, I can successfully connect... What am I missing? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bj?rn T Johansen btj at havleik.no -----------------------...

...39;s one of those things that seems like it should work but does not. My rails app (and ''rails console'') clearly knows where my data is as I can see my data. When I run ''rails dbconsole'' I can not get in, I get this error: Couldn''t find database client: psql. Check your $PATH and try again. Up to now I just log in to pgsql directly and I am in, just curious to use the rails tool. Environment: Rails 3, 1.9.2, rvm. If you''ve seen this please let me know, I don''t yet see anything in searches. David -- You received this message beca...

hi, Im running the following sql statment which returns 1 result. pSql = "SELECT sum(amount) FROM payments WHERE expected_pay_date LIKE ''"+pWholeDate+"%'' AND invoice_id IS null " aResult = Payment.find_by_sql(pSql) how can I get the result of this? (when do...

HI, I got this error when i am testing my rails application. I dont have the table named ''instructions''. But it shows a error like "ERROR: relation "instructions" does not exist". Totally, I got same error for 64 tests as 64 errors. I am using rails 3.0, Ruby 1.9.2, Netbeans 6.8. PS: I didnt creat Instruction manual for rails application. *Error:

...on that file being set up: file { ''/tmp/setupdb.sql'' : source => "puppet:///modules/${module_name}/setupdb.sql", mode => 644, backup => false, } exec { ''Setup the database'': command => ''psql ${databasename} -f /tmp/setupdb.sql'', onlyif => ''psql ... | grep ...'', # Some condition to check whether a table exists, for example. requires => File[''/tmp/setupdb.sql''], } The problem with this is that it looks procedural, a...

i have installed database POSTGRESQL for storing call details. when i restart database i get the error. [root at localhost server]# psql -h 127.0.0.1 -U asterisk Password psql: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? THIS IS MY /VAR/LIB/PGSQL/DATA/POSTGRESQL.CONF # CONNECTIONS AND AUTHENTICATION #------------------------...

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:

...cemail. As soon as I press the option the server crashes. I ran asterisk up inside gdb and got the following stack trace ==================================================================== Program received signal SIGSEGV, Segmentation fault. 0x00140adf in CI_read_fields () from /usr/lib/libodbcpsql.so (gdb) bt #0 0x00140adf in CI_read_fields () from /usr/lib/libodbcpsql.so #1 0x001594dc in QR_fetch_tuples () from /usr/lib/libodbcpsql.so #2 0x0014255e in CC_send_query () from /usr/lib/libodbcpsql.so #3 0x0015c87c in SC_execute () from /usr/lib/libodbcpsql.so #4 0x0014bd60 in PG_SQLExecute...

...ase in '/var/opt/rh/rh-postgresql95/lib/pgsql/data' * Initialized, logs are in /var/lib/pgsql/initdb_rh-postgresql95-postgresql.log [root at HOME1P jason]# service rh-postgresql95-postgresql start Starting rh-postgresql95-postgresql service: [ OK ] [root at HOME1P jason]# psql psql: FATAL: role "root" does not exist [root at HOME1P jason]# any ideas? Jason On 11/02/2016 05:04 PM, John R Pierce wrote: > On 11/2/2016 1:49 PM, Jason Welsh wrote: >> on the old postgresql that comes with centos 6? >> Ive asked google over and over and he wont...

on the old postgresql that comes with centos 6? Ive asked google over and over and he wont tell me. :( (im trying to install it as a requirement for NIPAP) Jason

...use of an sql statment to get the results required. However this just doesnt seem right for rails, as ive managed to develop the whole project without using any other pure sql. Is there a cleaner way of doing this, but gaining the same results. thanks scott #sql to find all invoices pSql = "SELECT DISTINCT invoices.id, invoices.invoice_number, invoices.approve_date, invoices.sent_date, invoices.paid_date FROM projects, payments, invoices WHERE projects.id = payments.project_id AND payments.invoice_id = invoices.id AND projects.i...

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: http://lists.digium.com/pipermail/asterisk-users/attachments/20091115/cbdd0700/attachment.htm

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

So thanks to Craig, i got up and running on rails 2.2.2, though now i''m dealing with a whole new can of worms. I''ve done a good bit o searching and haven''t found any solid leads. I''m using the simple_captcha plugin on my site, and all is well until i call that plugin. http://www.pastie.org/347721 ActionView::TemplateError (undefined method