foneman
Last Activity: Mar 21 '08, 10:46 PM
Joined: Mar 7 '08
Location:
-
I figured it out on my own. It has to do with how PHP and Postgres use memory. -
If you know PHP you can write your own script and transfer it from the command line.Leave a comment:
-
If you know PHP you can write your own script and transfer it from the command line.Leave a comment:
-
I figured it out. It's all about how PHP and Postgres use memory.Leave a comment:
-
There are several commercial programs that will do that for you. Otherwise you will have to write your own scripts. I've done it from Access to Postgres thru PHP and a web server. Makes a difference as to how much data, database compatability, etc.Leave a comment:
-
I've done it from MSAccess to PostgreSQL using PHP through a web server. What kind of scripts are you talking about and how much data?Leave a comment:
-
If it will export data as a CSV file, comma delimited that is, then Excel can convert it. I do it with a PHP script on a web server using the SpreadsheetWrit er module in Pear.Leave a comment:
-
pgAdmin III is a GUI frontend for postgres. You can do everything in it, you don't need the command line at all. You can backup and restore from the menu.Leave a comment:
-
The plot thickens. I created a schema in the original database and duplicated all the tables and views. Imported all the data from the Access database. Performance of the newly created schema is he same as the duplicated databases. This time, however, the performance of the original schema suffered by doubling the pull time. Dropping the schema restored the performance of the original schema. I give up. There's no documentation that helps, and appears...Leave a comment:
-
PostgreSQL multiple databases
I'm running Sambar 7.0, PHP 5.2 and PostgreSQL 8.2 with WinXP. I built a database that's fed with form data, and created summaries with views and PHP scripts. I cloned the database two different ways. One way used pg_dump out of the existing and pg_restore into the new, the other method was to maually execute the SQL to create all the objects. Using the same summary script edited to point to the other database no matter how it was created takes more... -
Maybe I should post to the PostGreSQL forum?Leave a comment:
-
So from PHP how do you address each schema if the tables and queries are named the same? The deeper I get into this, the harder it gets. I noticed that someone in another forum created two identical databases in a cluster and can connect to one but not the other. This doesn't bode well with me. Using pgAdmin III to execute the views in both databases, they run comparably, in the ms. Pulling the data through a web server with PHP gives a full page...Leave a comment:
-
Thank you, but......!
I really appreciate the quick response! Thanks for the reply, but after finding the statistics portion of PostGreSQL, I've figured out the second database isn't scanning the indexes that were set up. This would explain the fact that the PHP script works, but is extremely slow. Why would PostGres use the indexes in one database, but not the other?Leave a comment:
-
PHP or PostgreSQL problem?
I'm running Sambar 7.0, PHP 5.2 and PostgreSQL 8.2 with WinXP. I built a database that's fed with form data, and created summaries with views and PHP scripts. Pulling a web summary that has a years worth of data comes up in less than 20 seconds. I cloned the database two different ways. One way used pg_dump out of the existing and pg_restore into the new, the other method was to maually execute the SQL to create all the objects. Using the same summary...
No activity results to display
Leave a comment: