Tag Info

This is one of those "It depends" questions. Performance depends on resources, contention, configuration, and the VM engine Uncontended VM host: If you properly resource a VM with uncontended high performance locally-attached or SAN storage, low contention for CPU resources, no memory overcommit or contention, fast dedicated network access, etc, it'll ...

Answer to question SELECT DISTINCT ON (name, zonedistrict_id) ST_Union(geom) as geom, gid, name, zonedistrict_id, zonestyle_id, longname FROM zones GROUP BY gid, name, zonedistrict_id, zonestyle_id, longname ORDER BY name, zonedistrict_id, zonestyle_id; It depends on what you are actually trying to achieve and what version of Postgres you are ...

In general I have doubts about database servers on a VM. I don't doubt it is possible as per the previous answer but it strikes me as a complexity loss particularly for PostgreSQL where you could instead run several clusters on the same system without virtualization as long as you different IP addresses or ports. The thing people talk about on the pro side ...

First try connecting to the database as the postgres user jay@machine$ sudo su postgres postgres@machine$ psql Then create a new user, and why not create a database if you haven't already postgres=# CREATE USER jay WITH password 'donttell'; postgres=# CREATE DATABASE gis; postgres=# \q You should now be able to connect as yourself jay@machine$ psql ...

Try this: Re: could not change directory to "/root": Apparently you did "su postgres" from the root account, so you're still in root's home directory. It'd be better to do "su - postgres" to ensure you've acquired all of the postgres account's environment. Reading "man su" might help you out here.

The column "row_num" doesn't exist because the logical order of processing requires the dbms to apply the WHERE clause before it evaluates the SELECT clause. The windowing function is part of the SELECT clause, so its alias isn't accessible in the same statement's WHERE clause. The FROM clause is the very first part of the statement to be evaluated. That's ...

Just don't leave the Database field empty in the connection dialog. When left empty, it will attempt to connect to a database named after your OS login name, which probably doesn't exist in your case. The Host field should be left empty to use a Unix domain socket connection, as hinted by the snippet of your pg_hba.conf shown in the question. When you put ...

Turns out to have been a bug in the GEOS package-- there is an announcement on the postgis-users list. The link to the bug report is here.

From this listing it looks like there is a package named postgresql-9.2-postgis2. You may have to add a new apt repository to the existing ones. In this, you can find help here.