Tagged Questions
0
votes
0answers
58 views
How to import a text file with '|' delimited data to PostgreSQL database? [closed]
I have a text file with | delimited data that I want to import to a table in PostgreSQL database. PgAdminIII only exports CSV files. I converted the file to a CSV file using MS excel but still was ...
0
votes
1answer
59 views
“relation does not exist” trying to import mysql dump into postgres
environment:
ubuntu 10.04
mysql server 5.1.69
postgres 9.2
Here's the sequence of steps:
created a new postgres database, myDatabase
executed this command: mysqldump -u root -p ...
0
votes
0answers
65 views
Writing with multiple psql processes to database seems to damage data
I have a couple terabytes of CSV data that I am trying to import into a PostgreSQL 8.4 database (on a RedHat 6.2 server), whose data directory is initialized on a multipath hardware RAID. There are ...
1
vote
1answer
75 views
Postgres copy data with \xYY as plain string instead of interpreting as encoded string
I have a log file full of URLs, generated by Bro IDS.
When Bro logs a URL with non-ascii characters in it, it inserts \xYY where YY is the hexadecimal character code. Also, some URLs contain "\x".
...
2
votes
2answers
2k views
PostgreSQL not working, pgAdmin always says server not listening
I am brand new at this so maybe it's a simple mistake. I was given a very large .sql file with the instructions to make a copy of a database locally on a computer. I was told "to be able to install ...
0
votes
2answers
172 views
PostgreSQL replication and large import
I am tasked with making large PostgreSQL imports to master instance, and then replicate it across the nodes as read-only data.
Still, the CMS system has to be able to write data and replicate across ...
1
vote
1answer
254 views
How to troubleshoot COPY FROM inserting less rows then expected?
I have a CSV (tab-delimited in fact) file with 7,590,051 lines, according to wc -l, which I want to import using COPY FROM. I removed the table's primary key, so it has no constraints.
I ran COPY ...
2
votes
2answers
113 views
Postgresql: Two concurrent COPY FROM
I'm importing several gigantic csv files into a table - so I'm wondering what would happen if I ran COPY FROM jobs concurrently?
1
vote
1answer
133 views
PG_bulkload utility postgresql need help
i am using COPY command to export the data to the out file with changes made to the data before export using option ST_asBinary() using command
COPY (
SELECT st_asBinary(geom) FROM n_america
) TO ...
2
votes
2answers
578 views
Importing LARGE quantity of data into a PostgreSQL database
I am importing a large amount of data into a PostgreSQL server (across multiple databases on the server).
When I last attempted to import the data, it effectively "crashed" my machine (Ubuntu ...
1
vote
1answer
199 views
How to generate PostgreSQL COPY bin files?
My Googlefu is failing me. Are there any code snippets, either in Python or FORTRAN, that shows how to create binary files to be used by the COPY command in PostgreSQL?
