Your source is in no way official. It dates to 2011 and I don’t even recognize the authors. If the money type was officially “discouraged” PostgreSQL would say so in the manual – which it doesn’t. For a more official source, read this thread in pgsql-general (from just this week!), with statements from core developers … Read more
If you want to avoid using MacPorts, you can download the Postgres App and place it into the Application directory. Then, specify the location of newly downloaded pg_config: gem install pg — –with-pg-config=/Applications/Postgres.app/Contents/Versions/latest/bin/pg_config If you run in to missing headers problem, try specifying the include directory of the app: gem install pg — –with-pg-include=”/Applications/Postgres.app/Contents/Versions/latest/include/”
Just increasing max_connections is bad idea. You need to increase shared_buffers and kernel.shmmax as well. Considerations max_connections determines the maximum number of concurrent connections to the database server. The default is typically 100 connections. Before increasing your connection count you might need to scale up your deployment. But before that, you should consider whether you … Read more
It depends on a lot of factors – but most crucially: complexity of calculations (prefer doing complex crunching on an app-server, since that scales out; rather than a db server, which scales up) volume of data (if you need to access/aggregate a lot of data, doing it at the db server will save bandwidth, and … Read more
Use LOWER function to convert the strings to lower case before comparing. Try this: SELECT id FROM groups WHERE LOWER(name)=LOWER(‘Administrator’)
WARNING: If you delete postmaster.pid without making sure there are really no postgres processes running you, could permanently corrupt your database. (PostgreSQL should delete it automatically if the postmaster has exited.). SOLUTION: This fixed the issue–I deleted this file, and then everything worked! /usr/local/var/postgres/postmaster.pid — and here is how I figured out why this needed … Read more
Of course, you will get a fatal error for authenticating, because you do not include a user name… Try this one, it is OK for me 🙂 psql -U username -d myDataBase -a -f myInsertFile If the database is remote, use the same command with host psql -h host -U username -d myDataBase -a -f … Read more
There are two tools to look at, depending on how you created the dump file. Your first source of reference should be the man page pg_dump as that is what creates the dump itself. It says: Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands … Read more
Why are you storing x,y in separated columns? I strongly suggest you to store them as geometry or geography to avoid unnecessary casting overhead in query time. That being said, you can compute and check distances in miles using ST_DWithin or ST_Distance: (Test data) CREATE TABLE building (name text, long numeric, lat numeric); INSERT INTO … Read more
No. Since there is no natural order of rows in a database table, all you have to work with is the values in your table. Well, there are the Postgres specific system columns cmin and ctid you could abuse to some degree. The tuple ID (ctid) contains the file block number and position in the … Read more