im trying to export from one postgres db to another but im having big problems
does any one know of a quick and easy tutorial for a novis linux user that explanes and shows me how to do a
...
Hello everyone, I have a PostgreSQL database installed into a VMWare session on a server. I connect to the database from an application but sometimes it goes getting connection lost with this ...
I have copy of PostgreSQL Server 8.4 installed on a machine with Windows Vista. I had the server working fine for a while, but when I tried to enable external IP addresses to access the serve...
Postgres sql does not use the index created on the table
select count(cust) from tableA
where
(col1 = 1)
and
(col2 = 2)
and
(col3 betwee 0 and 100)
Index creat...
When I do:
createdb -E=UNICODE -U postgres SomeDbName
the results of
psql -l
will show a line like
SomeDbName | postgres | UTF8
Why does it do this? I have another server ...
We've been using using SQL Server 2000 Standard Edition for many years, and now we're considering moving to PostgreSQL 8.3.
The Index Tuning Wizard in SQL Server has been invaluable tool in...
Hi Experts,
I am using the PG triggers. I have a library that sends the trigger events to a process. It works fine when I have small number of updates to generate triggers. If I increa...
Hi,
Can anybody help me to convert my sql database to postgre database
Hello Experts,
I ran this once, but I lost the instruction, and I googled it but with no luck. Does any of you know what is the instruction on PostgreSQL for knowing how many current open c...
Sometimes I get this error when working with PostgreSQL for several hours (reloading one page all the time). "FATAL: connection limit exceeded for non-superusers"
How can this be fixed?
Hi Experts
Can PostgreSQL installed on windows? is there any tech resources/web ?
Thanks
Dishan
I'm having a problem with a Gridview's update statement in VS2005/Postgress SQL server. On testing this on my local PC running VS2005, and hitting a Postgres SQL server on a differnt box. I'm...
How do you use UUID (new in 8.3) as the default value instead of bigserial? I have a need to guarantee uniqueness over an extremely large number of records and would prefer using UUID due to i...
If I'm executing a statement the first time it takes 5 seconds, second and further times it takes 20ms. The only reason I can see is the data buffer.
How can I monitor the usage of the buff...
All I have a table in a postgre database that I have inherited that contains records that self join. It is a heirarchy tree for supervisors and employees.
The sample table layout is below:
t...
I currently backup our postgres database using pg_dump, which dumps it to a .sql file. I was wondering if I can simply copy the entire data folder which resides in /var/lib/postgres
If I c...
I am installing sql-ledger which uses postgreSQL. The installation instructions for sql-ledger say:
*********
You also have to add some users to your postgres DB
The easiest way to tes...
Dear experts,
I'm New to Linux and Postgre.
I've installed PostgreSQL 8.2 and phpPgAdmin in Ubuntu
Now, please tell me how to start phpPgAdmin
Thank you
We've got a PostgreSQL 7.4.18 server running on a SuSe Linux 10.2 box, configured with kernel 2.6.18, with the data directory stored on a seperate XFS partition.
The total size of all the d...
Hi,
I want to create a trigger that will update a column when an INSERT tries to insert a row with a duplicate key.
Take this query for example:
INSERT INTO sessions SET
data = 'so...
I have been fighting with this issue now for a couple of weeks and I really cannot get my head around it.
I have an application that I am currently developing, all code is written in Java, ...
I use the sql code below to find if an existing record exist for the same resource in the same date/time range. So the resource 'Conference Room B' can not be double booked.
There is an ex...
How do you do a multiple outer join?
I have 3 tables:
1. client
2. phone
3. email
Client is zero to many relationship to phone
Client is zero to many relationship to email
Link betwee...
I need to convert a MySQL dump file (about 10 MB worth of inserts, spanning over close to 80 tables) to Postgres. I'm hoping there's an automatic process or a good tutorial on how to get this ...
I have a large Postgresql 7.3 database on a Linux RHEL3 server, and I need to quickly make a very detailed ER diagram to use in a grant proposal for rewriting our (small college) system (ERW f...
