Hi ,
please let me know how I can connect postgresql using squirrel sql client
3.4.0.
Thanks Regards
Arindam Mondal
the dependent objects too.
Command was: DROP SCHEMA public;
pg_restore: [archiver (db)] could not execute query: ERROR: schema
public already exists
Please help.
-- Arindam
PS: The scripts that we execute after the install is complete are the following:
-- sql_file.sql
CREATE LANGUAGE plpgsql
.
Thanks,
Arindam
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On 2/8/07, Tom Lane [EMAIL PROTECTED] wrote:
Arindam [EMAIL PROTECTED] writes:
I tried dumping data in tar format using the pg_dump utility (with
version 7.2.1) and restoring it using pg_restore utility (with version
8.1.5). But on running this command:
pg_restore -d mydb -C -u my_dump_file
On 2/8/07, Tom Lane [EMAIL PROTECTED] wrote:
Arindam [EMAIL PROTECTED] writes:
On 2/8/07, Tom Lane [EMAIL PROTECTED] wrote:
Now you *should* be using the newer pg_dump to dump from the old
database --- that's considered good practice. But you need an
up-to-date pg_restore to read its output
, this worked in 7.2.1, but now that we are upgrading it - it
does not work anymore because pg_passwd is no longer available.
What alternatives exist in 8.1.5 to carry out the same thing.
-- Arindam
---(end of broadcast)---
TIP 3: Have you checked our
am a little concerned
about what all major changes have happened that will likely affect my
build.
What all has moved out of the tar that is available for download ( I
am talking about postgresql-ver.tar.gz ).
- Arindam
---(end of broadcast)---
TIP
On 1/4/07, Tom Lane [EMAIL PROTECTED] wrote:
Arindam [EMAIL PROTECTED] writes:
I am in a fix. Do I need to separately download the jdbc drivers and
build them into a jar file?
The jdbc driver is distributed separately now, yes. See
http://jdbc.postgresql.org/
regards
