restore from data folder

[andretti]

yes, the entire folder

[andretti]

G:\PostgreSQL\8.3>cd data

G:\PostgreSQL\8.3\data>dir
Том в устройстве G не имеет метки.
Серийный номер тома: 4090-FB7E

Содержимое папки G:\PostgreSQL\8.3\data

15.12.2009 21:03 <DIR> .
15.12.2009 21:03 <DIR> ..
15.12.2009 06:24 <DIR> base
16.12.2009 00:19 <DIR> global
14.12.2009 22:18 <DIR> pg_clog
14.12.2009 23:04 3 142 pg_hba.conf
05.12.2008 13:33 1 496 pg_ident.conf
16.12.2009 00:00 <DIR> pg_log
14.12.2009 22:19 <DIR> pg_multixact
14.12.2009 22:19 <DIR> pg_subtrans
14.12.2009 21:41 <DIR> pg_tblspc
14.12.2009 21:41 <DIR> pg_twophase
05.12.2008 13:33 4 PG_VERSION
14.12.2009 22:19 <DIR> pg_xlog
15.09.2009 16:52 17 151 postgresql.conf
15.12.2009 21:03 65 postmaster.opts
15.12.2009 21:03 28 postmaster.pid
05.12.2008 13:33 17 149 Копия postgresql.conf
7 файлов 39 035 байт
11 папок 179 208 450 048 байт свободно

G:\PostgreSQL\8.3\data>

[kraada]

Unfortunately I don't know what to tell you other than that your data simply is not there. This is why we do encourage people to actually make database backups and we've included those functions in the latest Beta (and will be improving upon them in the next beta).

[andretti]

ok, but what was the sense in the following then?

Did you copy the entire data folder including all of its subfolders over?

[kraada]

Because if you'd missed the pg_xlog subdirectory and the database was running at the time there was an outside chance that if you'd recopied over the entire folder including that subdirectory the database might fix itself. But since you did and it's not working, obviously that remedy is out.

[andretti]

it sounds odd but it seems that I am up and running now..

i have just wiped out data folder from PostgreSQL installation, and copied data into existing installation pretty straightforward.
Then I granted full access to postgres to all inheritors and its working now

the point is that almost surely installing DB engine over data folder did not work for me, maybe a permission issue..

thanks for your help

[kraada]

Odd, but I'm glad to hear you got everything working again!