Background:
Thousands of folders and files filled with client data on the linux
samba server.
Searching for data is difficult due to ever-changing directory
structures and naming schemes.
Example (exaggerating to make a point):
/air/water/vegetable/animal/broccoli/potato/crabby_client.doc
/animal/broccoli/air/vegetable/poise_and_honor.pdf
It goes on for about 650,000 files
I used the following command to gather all file and directory names.
"/abc" is the main directory on the linux samba server where all
company data is located:
root@acme:/# ls -Ralh /abc > /home/mike/file_output.txt
file_output.txt is 33 megs. and lists approximately 650,000 file names
and their directory paths.
I want to pull all the file name info. and directory path info. from
"file_output.txt" and place each file name into a postgresql database
along with the related file location information.
The ultimate goal is to be able to make an alpha-numeric query and be
presented with matching file names and their location on the samba
server.
How do I pull the data from "file_output.txt" and place it into the
postgres database?
Any guidance and pointed RTFM declarations greatly appreciated.
Thanks,
Mike