[ADMIN] postgresql 8.x history
Hi, what the opinion about this http://suckit.blog.hu/2009/09/26/postgresql_history I got this link from my friend.
Re: [ADMIN] postgresql 8.x history
* dayat (dayat.a...@gmail.com) wrote: > Hi, what the opinion about this > http://suckit.blog.hu/2009/09/26/postgresql_history > I got this link from my friend. It's not terrible, but it's very, very, very selective. It's not a good general benchmark. Also, the difference between 8.3 and 8.4 isn't very large for this workload while there are many workloads where we're pretty confident 8.4 will perform better. Personally, I believe the 'real world' work cases will be much improved under 8.4. Thanks, Stephen signature.asc Description: Digital signature
[ADMIN] Help With Database Backup
Hello there, I am new to PostgreSQL, succeded in running a little database on my dev. machine and now I am having problems exporting the local database to the one I want to use on my site online. I am getting errors when I try to run the SQL online with phpPgAdmin. I exported / backup the local database using pgAmin, I choose the PLAIN format and then selected the No Owner option as well as the Schema Only option (how canI export schema and data at once). It is the SQL statements from the backup that I am trying to execute online. Am I missing something, I'll appreciate suggestions / links e.t.c Kind Regards. - Charles Odili Xchequer Nigeriia -- View this message in context: http://www.nabble.com/Help-With-Database-Backup-tp25680203p25680203.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Help With Database Backup
On Wed, Sep 30, 2009 at 6:38 AM, chalu wrote: > > Hello there, I am new to PostgreSQL, succeded in running a little database on > my dev. machine and now I am having problems exporting the local database to > the one I want to use on my site online. I am getting errors when I try to > run the SQL online with phpPgAdmin. > > I exported / backup the local database using pgAmin, I choose the PLAIN > format and then selected the No Owner option as well as the Schema Only > option (how canI export schema and data at once). > It is the SQL statements from the backup that I am trying to execute online. > > Am I missing something, I'll appreciate suggestions / links e.t.c > Kind Regards. What error message are you getting? The most common problem is running restore against a db that already has part of the schema in place. You might need to dropdb / createdb a new db for it to work. Just guessing tho -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Help With Database Backup
Hi, Hello there, I am new to PostgreSQL, succeded in running a little database on my dev. machine and now I am having problems exporting the local database to the one I want to use on my site online. I am getting errors when I try to run the SQL online with phpPgAdmin. What errors are you getting? It's impossible to give you any help unless you can provide a bit more information. I exported / backup the local database using pgAmin, I choose the PLAIN format and then selected the No Owner option as well as the Schema Only option (how canI export schema and data at once). I believe if you don't select "schema only" you get schema and data. Regards, Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin