Fatal error: more than one row returned by a subquery etc.

[Flag_Hippo]

my database is over 12GB and my free Disk Space is not even 1GB

i try to delete as much as i can

but do i have to rebuild the cache again for hours ?

Since the previous rebuild did not complete you will need to do it again and if PostgreSQL has more free space to work with it could be faster.

[uludaq]

Thank you so much for your help and fast response!

Now i only got the problem to get my disk space free,is it possible to cut out folders of the database and replace them another time?

i need to review my last sessions but cant create enough free space at the moment

[Flag_Hippo]

That's not possible unless you purge hands from the database but you will still need free space for PostgreSQL to complete the necessary housekeeping afterwards. If you want to review your most recent sessions you can also import those hands into a new database.

[uludaq]

i cant purge any hand because i got the same error message in this option like in the beginning of this thread


how i could get such a big database over the time and now dont know how to handle the problem to get more free space

[Flag_Hippo]

Go to this folder:

C:\Program Files\PostgreSQL\x.y\data\pg_log

where x.y is your PostgreSQL version although you may have it installed in another location. If this folder is taking up space you can safely delete the contents of that folder otherwise you will need to find some space from elsewhere and programs like CCleaner can help with that. The only other options I can suggest would be to start a smaller database and then delete the original or move things to another drive/upgrade if possible.

[uludaq]

u mean i can delete files in this folder without any problems for my database and statistics later on?

https://imgur.com/28CR36h

[Flag_Hippo]

C:\Program Files\PostgreSQL\x.y\data\pg_log

Do not delete anything in the 'data' folder except the content of the subfolder I specified called 'pg_log' otherwise you could damage/delete your database. Go inside the 'data' folder and then the 'pg_logs' folder - this will just contain text files and these can be safely deleted if they are taking up a large amount of space.

[uludaq]

i am sry but i did not get it yet

i now got more space free than my database is,did a housekeeping,did a cache rebuild but stil got the same error message

i did a backup now on another disk for my secure too

maybe i now start a new database and import hands manually?

[Flag_Hippo]

If you still don't have enough free space then you can start a new database to import hands but the same rules will apply to that database meaning if it gets too big relative to your free space then PostgreSQL may not be able to maintain the database.

[uludaq]

now i am totally confused and it stil dont work

i created a new database and tried to track hands while playing but i didn`t work too

also i cant delete the old database

is it possible that my postgres dont work properly because i got a red sign and alert messages

can i reinstall all new and work with a backup of my database?