All Questions
Tagged with datafile postgresql
7 questions
0
votes
1
answer
213
views
Postgres's equivalent for Oracle's datafile recovery
In oracle, one can do a recovery from datafiles.
Does Postgres have an equivalent procedure?
I am already aware of the WAL files in Postgres, but I believe this is different. Datafiles in Oracle are ...
- 331
1
vote
2
answers
3k
views
Migrating Postgres server from Windows to Linux
Simple question: I want to migrate all of a Postgres server's data, schema, roles, everything from Windows to Linux.
Can I just copy the contents of the %PGDATA% directory in Windows to which the ...
- 354
2
votes
1
answer
106
views
How Database Formats Files for Disk
This SO answer outlines how MySQL organizes its database into files, but doesn't describe the structure of the files themselves.
I am wondering, at the physical level, how relational database ...
- 221
1
vote
2
answers
2k
views
Storing blobs outside the database
I had a PostgreSQL database with loads of scanned documents, as a document bytea column in the table scans, with hundreds of thousands of documents that was large and inconvenient to backup. Also, ...
- 5,028
2
votes
1
answer
370
views
Pausing the import of an SQL file in Postgresql?
I am currently importing a large database (6 - 7 GB's) into my postgresql on Ubuntu. It's taking sometime to do. A problem has come up where I need to physically relocate the laptop the postgresql is ...
- 21
0
votes
1
answer
10k
views
Save output from multiple SQL SELECT commands to a file
Within a Postgres function I would like to run a number of SQL SELECT commands and append the output to the same variable. After all the SELECT commands have run this output should be written to a ...
- 195
58
votes
6
answers
220k
views
How to insert (file) data into a PostgreSQL bytea column?
This question is not about bytea v. oid v. blobs v. large objects, etc.
I have a table containing a primary key integer field and a bytea field. I'd like to enter data into the bytea field. This ...
- 939