The dateformat is not specified in the backup file in older versions and when you restore the data the date may or may not be correct.
To set the date matching your backup you either add "set DateStyle to <date_format>" in the backup file or load psql, set the date, and then restore the data. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Mon, 4 Nov 2002, Rik Zandvoort wrote: > > > On maandag, nov 4, 2002, at 00:07 Europe/Amsterdam, Jonas Smedegaard > wrote: > > > > > On Sun, 3 Nov 2002, Rik Zandvoort wrote: > > > >> I am using the Dutch templates and did set the user date format to > >> dd-mm-yy. Now, making a backup I get a backup file with the date-data > >> in > >> format dd-mm-yy. > >> > >> Restoring this file with 'psql databasename < dataset-1.8.5.sql' > >> results > >> in a working set in which the dateformat is mm-dd-yy instead of > >> dd-mm-yy. > >> > >> Does somebody know if I have to use a different psql command to get > >> this > >> right? Now I have to make a second backup and restore a second time to > >> get the dd-mm-yy format again. > > > > Have you tried setting the dutch locale on the account you use when > > restoring? And checked for localisation options in PostgreSQL > > configuration? > > > > - Jonas > > The account is set to the Dutch locale, but nevertheless.... > I'll try to set localization for PostgreSQL, but first have to find out > how. All new to me. > Thanks for the tip Jonas, > > Rik > >
