58 days ago by diantokam

After succesfully install postgresql on slackware, the next point is to configuring postgresql so it can accessing from network ( local network). Step 1: edit postgresql.conf #mcedit /var/lib/pgsql/data/postgresql.conf change at the connections and authentication section, find the listen_addresses = ...

70 days ago by Six110

I hope that you use a Debian-based distro! sudo apt-get install postgresql Setup the postgres‘s password: sudo -u postgres psql \password digit the new password, then press Ctrl+D to exit from psql. Edit this file (adjust your version number, I’ve used 9.1 for write this guide) sudo vi /etc/postgres ...

79 days ago by Marcos

Pregunta Estoy teniendo un error que me muestra el siguiente mensaje Cuando intento crear una nueva BD desde pgAdmin3: ------------------------------------------------- Ha ocurrido un error: ERROR: no existe la columna «datconfig» LÍNEA 1: ...b.dattablespace AS spcoid, spcname, datallowconn, datconf ...

194 days ago by donp

I have occasionally dabbled in database design over the past few years. I once toyed with the idea of a church management database, which never really went anywhere. Mind you, the experts that examined it really liked the overall design, but I had some work to do with making it actually useful. Fast ...

228 days ago by Leo Hsu and Regina Obe

I'm one of those old-fashioned folks that debugs with print lines and raise notices. They're nice. They always work, you can put clock time stops in there and don't require any fancy configuration. At a certain point you do have to pull out a real debugger to see what is going on. This often happens ...

279 days ago by Leo Hsu and Regina Obe

We've started to play with PostgreSQL 9.1beta and the PgAdmin III 1.14.0 Beta 1. We'll briefly go over the cool gems found in PgAdmin III beta 1. Most of the new features are for navigating the upcoming PostgreSQL 9.1. Well first obstacle we ran into was we can't get our favorite extension, PostGIS, ...