On 3/10/2016 12:25 PM, Alka Gupta wrote:
Do you know if there is any encryption or security or will plainly copying the files will work? Do I need to know any db usernames and passwords, which obviously I don't have?
plain copy should be fine, any encryption would be file system level, and if it was so encrypted you wouldn't have even been able to /see/ the files. modify pg_hba.conf to have... local all all trust as the first non-comment line, and pooof, no security on the databases for local direct connections. there's nearly always a 'postgres' user which is the server owner, and primary database administrator account. you should create a unix user 'postgres', and use this user to start the database server via... pg_ctl -D /path/to/pg/data (other options if need) start and you should see any startup problems displayed on the console. if the server actually starts, then it should start logging to $PGDATA/pg_log/..... and you might tail the newest of those files to see whats going on. Q: is the pg_hba.conf and postgresql.conf files in the data directory, or was this a ubuntu/debian setup where they put them in /etc/pgsql/... ? if its a debian/ubuntu setup a bunch of things were moved around, logging is in /var/log/... the config files are in /etc and so forth. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general