Enable pgpass under Windows XP

-
These are the steps I used to enable pgpass under Windows XP.
  1. Create file with name: pgpass.conf with this information in it: hostname:port:database:username:password

    see this for file data format

  2. Move the file to the %APP_DATA%\postgresql directory of the user running the backup ( not the db server user - postgres). In my case it was: C:\Documents and Settings\Windows User Name\Application Data\postgresql.
  3. Add --no-password option to the backup statement like this: "C:\Program Files\PostgreSQL\9.X\bin\pg_dump.exe" -h localhost -U postgres --no-password -C -f "database_name_dump.sql" database_name_db
Done.

Comments

Post a Comment

Popular posts from this blog

Enable pgpass under Windows 7

-
Last year I have written a post about enabling pgpass under Windows XP . Today I repeated the procedure for Windows 7. Basically everything worked as before, with the following exception - the APPDATA directory in Win 7 is different. What I did first was to check the name of the user running PostgreSQL server process. Then log in as that user and find out where is the APPDATA directory for that user. echo %APPDATA% From that point on, just follow the instructions in the previous post. Good luck!
Read more

PHPUnit 4 on Windows 7

-
Download phpunit.phar from - http://phpunit.de/ Find your php bin directory. In my case it is: C:\Program Files (x86)\Zend\ZendServer\bin Add this directory to your path. In the same php bin directory create .bat file with the following content: @ECHO OFF set PHP_BIN=php.exe set FILE_PATH="C:\path\to\phpunit_phar_file\phpunit.phar" %PHP_BIN% %FILE_PATH% %* Done. phpunit will be available from any location.
Read more

Numeric Drop-down With PHP ranges

-
Image
Here is an easy way to generate form numeric drop-down with ranges. $form = new Zend_Form(); $ranges = array( range(1, 20, 1) , range(30, 100, 10) , range(200, 1000, 100) ); $a = array(); foreach ( $ranges as $range ) { foreach ( $range as $r ) { $a[$r] = $r; } } $form->addElement('select', 'quantity', array( 'label' => 'Quantity' , 'required' => false , 'class' => 'form-control' , 'multiOptions' => array( '' => '--Select--' ) + $a )); Please note that the ranges are with different steps. Here is the result:
Read more