Search Results

Search found 1505 results on 61 pages for 'postgresql'.

Page 22/61 | < Previous Page | 18 19 20 21 22 23 24 25 26 27 28 29  | Next Page >

• Why does SQLAlchemy with psycopg2 use_native_unicode have poor performance?

  - by Bob Dover

  I'm having a difficult time figuring out why a simple SELECT query is taking such a long time with sqlalchemy using raw SQL (I'm getting 14600 rows/sec, but when running the same query through psycopg2 without sqlalchemy, I'm getting 38421 rows/sec). After some poking around, I realized that toggling sqlalchemy's use_native_unicode parameter in…

  Read the article

• Can I tell if crashplan has backed up a particular file in a particular state?

  - by Chris Cogdon

  I would like to be able to tell, programmatically, if CrashPlan has backed-up a particular file, including the current updates to that file. I.e., that the current contents of a file are backed up. It's relatively easy to tell when CrashPlan last backed up a file: its file name appears in /usr/local/crashplan/log/backup_files.log.0, and with…

  Read the article

• Cannot start Postgres daemon after installing with Yum

  - by Sean the Bean

  I was trying to install Postgres 9.1.4 on Fedora 17 using Yum. If I do: sudo yum install postgres-libs sudo yum install postgres sudo yum install postgis All the installs appear to complete successfully (i.e., no errors), but I cannot start the Postgres daemon using: service postgresql initdb Like the official Postgres download guide…

  Read the article

• Cannot login to Postgrest database despite setting password for user 'postgres'

  - by Serg

  I'm trying to use pgAdmin III to manage my Postgres database. Here are the commands I've run on my machine: sudo apt-get install postgresql Then I installed the pgAdmin III application: sudo apt-get install pgadmin3 Next I focused on setting my username and password in order to login: sudo -u postgres psql postgres Here I set my…

  Read the article

• What package do install to get access to "psql" client on windows

  - by fmark

  What package do install to get access to "psql" client on windows xp? I don't want to install a server, only the command-line client, and maybe pg_dump and co. I am connecting to Postgresql 8.4 server.

  Read the article

• "No version information available" - After installing Postgres

  - by intellidiot

  I have installed Postgres 9.1.4 on an Ubuntu 12.04 (precise) 64-bit from here http://www.openscg.com/se/postgresql/packages.jsp, but right after installing many commands (programs) are throwing these following warnings in different combinations: /opt/postgres/9.1/lib/libxml2.so.2: no version information available…

  Read the article

• "pg_ctl: could not find postgres program executable" but only on startup?

  - by Kev

  I'm having a strange new issue with PostgreSQL. After the last two reboots it hasn't started properly, and that was the error in the log (it occurs early enough in the startup process to not say anything in Postgres' own logs.) Starting it manually via the Services window worked fine both times. Any clues?

  Read the article

• Ruby hangs when loading 'pg' or 'postgres' gem.

  - by Jake

  I recently installed postgresql using homebrew. When trying to use the 'pg' or 'postgresql' gem irb just hangs. Any ideas?

  Read the article

• decodeURIComponent for postgres

  - by maletin

  I use decodeURIComponent and encodeURIComponent in Javascript. Before I store this data in a UTF-8-PostgreSQL-Database, I should decode them: $my_data = pg_escape_string(utf8_encode($_POST['my_data'])); I'm looking for a PostgreSQL-Function to convert Javascript-Encoded Data.

  Read the article

• Accessing Internal Server from Outside through SSH

  - by myahya

  The issue is as follows: I am using Ubuntu Linux. I am working from home, and I need to access a PostgreSQL database severer within my company's network. Call the DB server X. For security reasons, only one machine can be accessed from the outside using ssh, call it Y. So the scenario is: Home <--SSH-- Y…

  Read the article

• Porting Oracle Date Manipulation

  - by Grasper

  I need to port this following from Oracle syntax to Postgresql. Both FLO_END_DT and FLO_START_DATE are of type DATE in Oracle, and TIMESTAMP WITHOUT TIME ZONE in Postgresql: SELECT TRUNC( TO_CHAR(ROUND(( FL.FLO_END_DT- FL.FLO_START_DT)* 24), '9999D99'),2) FROM FLOWS FL I am not familiar enough with…

  Read the article

• Is there a Veil-like plug-in for MySQL?

  - by Kevin

  We have a MySQL database and would like to have row-level security implemented at the database level. I have been playing with the Veil plug-in for PostgreSQL and like what it does. Is there something similar for MySQL so we do not have to convert over to PostgreSQL?

  Read the article

• Is there an in memory database that supports the DATE function?

  - by Chris J

  Hi, I am doing some unit testing for a DAO that works with postgresql. Some of the SQL queries that my DAO uses involve the DATE function. Is there an in-memory database that supports functions similar to the ones that postgresql does? Currently I am looking for support for the DATE function however, I…

  Read the article

• Dealing with errors during a copy from

  - by jlfenaux

  I've to import a file from an external source to a postgresql table. I tried to do it with \copy from , but I keep getting errors (additional columns) in the middle of the file. Is there a way to tell postgresql to ignore lines containing errors during a "\copy from" ? Thanks

  Read the article

• Multiple database connection in Rails

  - by Sanal

  I'm using active_delegate for multiple connection in Rails. Here I'm using mysql as master_database for some models,and postgresql for some other models. Problem is that when I try to access the mysql models, I'm getting the error below! Stack trace shows that, it is still using the postgresql adapter to…

  Read the article

• psqlODBC won't load after installing MS SQL ODBC driver on RHEL 6

  - by Kapil Vyas

  I had the PostgreSQL drivers working on my RHEL 6. But after I installed Microsoft® SQL Server® ODBC Driver 1.0 for Linux I can no longer connect to PosgreSQL data sources. I can connect to SQL Server data sources fine. When I had this same issue a week ago I uninstalled MS SQL Server ODBC driver from…

  Read the article

• Problems locating Redmine database

  - by zordor

  I have an active redmine but I can not find the database where it is running right now. It should be on PostgreSQL but the database where it should be running is empty. Does anybody have any idea how to check current database used by redmine? Please let me know if you need any extra information. …

  Read the article

• Disk space consumed

  - by aravind-zoniac

  I have a very serious problem here in one of my client server. The remote server is installed with REDHAT ES 5.2 and we have a postgresql as database. I was trying to clone the database. The hard drive had 32 GB of free space before taking clone. I started cloning the database and during the…

  Read the article

• Which version of Windows Server 2008?

  - by dragonmantank

  One of the projects I'm working on is looking like we're going to need to migrate from CentOS 5.4 over to something else (we need to run Postgresql 8.3+, and CentOS/RHEL only support 8.1), and one of the options will be Windows Server. Since 2008 R2 is out that's what I'm looking at. I'll…

  Read the article

• Database checksum features - redundant? useful?

  - by Eloff

  Just about every mainstream DB has a feature to calculate checksums per page, per sector, or per record. Now for a DB that does full recover after any crash, like PostgreSQL, is a checksum even useful? There will be no data loss as long as the xlog is ok, no matter what kind of corruption…

  Read the article

• Which is the best way to deploy a JBoss application?

  - by andreash

  Hi there, we are currently developing a JBoss application. To deploy it, we have a total of four servers (three years old). I am wondering which might be the best to do? There could be a load balancer (even a load-balancer cluster, for failover) in front of two servers, each holding one…

  Read the article

• Is there a network "tee"-alike with one leg returning to /dev/null ?

  - by Steff Davies

  I've just built a new PostgreSQL server for my employers, which is happily replicating using WALs. I'm now left with the problem of verifying its performance. One nice way which came up in conversation is to break replication with the slave caught up and then direct all production traffic…

  Read the article

• Simple queries occasionally running very slowly

  - by Johan

  I have some very simple queries that occasionally run very slowly. The table viewed_sites has about 10 - 20 rows. Running EXPLAIN ANALYZE always gives a runtime of less than 3 milliseconds. When the query is run automatically (every 10 seconds) it occasionally takes over a second to…

  Read the article

• How does one launch PhpPgAdmin?

  - by DarenW

  I just installed postgresql, php5 and in particular PhpPgAdmin using Ubuntu's synaptic app. The PHP is running fine, the http server (lighttpd) is working fine, and I can do pg a the command line. The only thing that remains a mystery is PhpPgAdmin - just how does one fire it up to…

  Read the article

• Update server version for postgres 9.1.2

  - by Nai

  I'm trying to run a postgis sql script and I'm running into the following error. Am I correct to say that updating my server version will fix it? If so, how can I go about updating it? I'm on Mac OSX Lion and installed Postgres via brew. Apparently I have an older version…

  Read the article

< Previous Page | 18 19 20 21 22 23 24 25 26 27 28 29  | Next Page >