Log in

PostgreSQL [entries|archive|friends|userinfo]
PostgreSQL Users

[ website | PostgreSQL Web site ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

PL/SQL and int to interval conversion [Aug. 3rd, 2007|07:09 pm]
PostgreSQL Users


How do I, in PL/SQL function, convert integer value to time interval? Integer specifies time interval, in milliseconds.

(I'm working on log parsing)
link3 comments|post comment

How to view database permissions [Jul. 31st, 2007|09:43 pm]
PostgreSQL Users

[mood |workingworking]

I'm fairly new to PostgreSQL, coming from a background in MySQL and, to a far lesser extent, Oracle 9i.

I noticed that psql allows me to view all table permissions in a database using \dp or \z. I can't figure out, however, how to view any privilges granted by a GRANT ALL PRIVILEGES ON DATABASE x TO y. I'm sure there has to be a way, even if it's by querying the system tables/catalogs.

So... will anyone tell me how to view these types of privileges?
link1 comment|post comment

Some photos from PGDay 2007 [Jul. 11th, 2007|09:23 am]
PostgreSQL Users

For the full PGDay coverage you can refer to http://www.planetpostgresql.org
linkpost comment

PGDay day one W00T! [Jul. 7th, 2007|07:04 am]
PostgreSQL Users
Ok, I'm tired, my legs hurts but I'm very very happy.

My PGDay started at 5 a.m. preparing last modification on slides of my mini courses.

The day started with first panic at 8.30 a.m., because a lot of people, more than we expecting, was at registration desk asking to be included in the first italian PostgreSQL Day.

My morning was very busy attending mini-courses about DBA base, advanced and just a little performance tuning talk on the veneziana room almost fullfilled with 40-50 people.

I'm very happy about my performance, some guy asked me many tecnical things and the Faunaly guys told me that my audience was very very happy.

I can't spend enough good words about PostgreSQL guys.

David Fetter was the first Postgresql that I've meet in florence, he gave us a lot of elephant pins, and pleased us staying at PLUG site. Thanks David w00t!

Josh Berkus it's fantastic, he speak very good italian, and he gave me a tequila bottle and a linux-freebsd t-shirt. Thank you Josh, sorry for my bad english.

I'm very happy to meet so cool guys, as dalibo guys (thank you Cedric someone told me that you have apreciate my talk).

The german guys are very cool.

Ok, first day was good, tomorrow I'll introduce Josh keynotes and then I'll be in the audience.

I'm looking forward to listen Simon Riggs PITR talk and meet Hans from Cybertec that just confirmed his talk tomorrow.

And this evening, we'll have a concert at PLUG, if you are in Prato, you are invited.
link2 comments|post comment

Grant question. [Jun. 6th, 2007|01:32 pm]
PostgreSQL Users


I have a user. let's call him "websitedev". I also have a database called "events" which was created by user "postgres". I have a php application that this user "websitedev" is able to connect to the database, the problem is it doesn't have permissions to access the tables.

grant all privileges on database events to websitedev with grant option;

But when I try to connect via the website application I am still getting.

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: permission denied for relation tablename in path/to/file.php on line 59


link6 comments|post comment

Italian PostgreSQL Day 2007 [May. 10th, 2007|11:46 am]
PostgreSQL Users
The PostgreSQL Day (aka PGDday) is a day of celebration. Celebration for PostgreSQL and, on a wider view, for the free software and open-source communities based in Italy and Europe.

The event (the first in Italy) will take place in Prato , Tuscany on July 6 and 7 2007, on the eve of the 21st anniversary of PostgreSQL, a project that was started on the 8th of July 1986, at the University of California, Berkeley.

The Italian PGDay 2007 is a chance for Italian and European users and developers of PostgreSQL to catch up, learn, build relationships, get to know each other and consolidate a real network of professionals that use this outstanding product for the daily management of relational and object databases.

Another fundamental goal for the event, is to promote the usage of PostgreSQL as a completely free tool for database management, a very competitive alternative to proprietary solutions.

Among the others, the most suitable audiences for the event (and the most suitable targets for PostgreSQL usage as well) are:

* government organisations
* schools and universities (for direct usage and educational purposes as well)
* small and middle size companies

PGDay is organised as a set of parallel talks, seminars, presentations, tutorials and practical workshops that will run throughout the day. Based on the target and the level of knowledge of the product, the happenings will be divided into:

* advanced technical level presentations
* basic technical level and use-case presentations

The event will be preceeded by a national and European initiative known as Road to PGDay 2007, whose aims are to promote PGDay throughout Italy and Europe by involving local free software communities such as LUGs.

More infos at: http://www.pgday.it/en
linkpost comment

Great PostgreSQL DBA job! [May. 9th, 2007|03:25 pm]
PostgreSQL Users

I hope you don't mind me posting this here. I am looking for experienced PostgreSQL DBAs (a Jr and a Sr level) for a really exciting position in Utah, in a company culture where you can work and play hard in a great team environment with challenging technical problems (like massive pageviews and transactions).
Skiing is optional.
You can read a bit more on my LJ blog and contact me by email if you are interested or have a buddy who is passionate about open source and life in general.
linkpost comment

synching db's over modem / slip conn. [Jun. 16th, 2006|03:02 pm]
PostgreSQL Users
Hello. I have N remote stations with postgres 7.4.6 (for data collecting). I need to perform periodic sychronization one MASTER station with N remote stations via slip connection. Please help me to find a simple solution of this problem. Thanks.
link6 comments|post comment

Database Migration [Mar. 22nd, 2006|09:14 am]
PostgreSQL Users

Can anyone suggest a utility or a script to convert a MySQL database to a PostgreSQL database? I've done a few google searches, but I haven't found anything suitable.

link8 comments|post comment

reserved schema names? [Oct. 13th, 2005|01:29 am]
PostgreSQL Users

Anybody know what other reserved schema names there are besides 'pg_*'? I tried to:
mcb211=# create schema '2005';
ERROR:  syntax error at or near "'2005'" at character 15
LINE 1: create schema '2005';
link3 comments|post comment

[ viewing | 10 entries back ]
[ go | earlier/later ]