I sent this message to INTERFACES, but there is no answer, maybe on
ADMIN list somebody knows something about it...
From the docs i understood, that with COPY SQL command we should use
for synchr. sending:
PQexec
PQResultstatus returns PGRES_COPY_OUT
PQputCopyData
PQputCopy
Louis, first try to start Your PostgreSQL engine "with a hand" from
command line window like this:
/usr/local/pgsql/bin/postmaster -D /home/postgres/data/psql
...and look, what's will be happen.
Of course, these "/usr/local/pgsql/bin/" shold be Your path do
"postmaster" binary and "/home/postgre
Some ideas:
With Slony one the one of these server You can install paralell a
"central" database and "slave". They can work on two database clusters
with running two PostgreSQL instances (on two different ports).
Read the docs about dbmirror too (source tree - contrib/dbmirror).
You can make Yo
Mary Anderson wrote:
Hi all,
I am new to postgresql and have been called upon to set up a
database to be used by two groups. One group (mine) is strictly a
UNIX shop. The other group (theirs) is strictly a Windows shop. What
is the best way to go.
First, does postgresql have replicati
gunartha.nyoman napisał(a):
hi,
I am new comer in this millis...
i have a poblem, how to add a field/column in existing table without oids.
if i create new table i can add field oids
Thank alot before
regrads
Nyoman/bali
So - create a new table with this same structure, but with oids, copy
I checked the libraries used by pg_ctl and postmaster. They use proper
libs without use LD_LIBRARY_PATH, but I used it "for safety" in the
postmaster starting script.
One more big thanks.
Adam
Jorge Serván wrote:
The Libraries used are solved by the liker. Try ldd to
show the paths of the li
I had problem such this. I've got 8.1.3 client and 8.0.6 server. But
psql 8.1.3 warned me, that some \? functions can not work properly. I've
resolved this problem in very simply way. I got binary psql from 8.0.x
and run. Psql program is a client program, that uses libpq library, so
it is (I th
Did You specified the database ? In PostgreSQL You are logging into
database, not into DBMS, like in MySQL.
For test users try template1 first, for example psql -h yourhost -U
somebody -d template1
Did You grant those users rights to database wchich they are connecting
to ?
Regards
Adam
[EMAIL
The problem is resolved. OpenOffice doesn't edit tables without primary
key with any driver (I've tried JDBC,native OpenOffice, ODBC). But - the
primary key can't be ignored, when it is made on OID.
Greetings
Adam
Adam Radlowski wrote:
I'm using very often OpenOffice to ad
I'm using very often OpenOffice to administrate databases (It has
options, wchich are not present in pgadmin3).
If I use JDBC connection and server don't requiers md5 passwords, I can
edit and administrate the databases/tables via OpenOffice and JDBC. I
can only read the tables. When server requ
I had problems, like that. I've omitted them using "plain" format (SQL
script file) of dump file. I restore data from "plain" format with psql
- using command "\i FILE". It work always. If You gzip this "plain" file
- You become simillar volume of file using binary dump format.
Greetings
Adam
If "more.com" (not more.exe) in windos XP Pro is not installed in
WINDIR/system32 (WINDIR directory is usually after standard installation
called WINDOWS), You can it find on install disk in directory "i386" as
more.co_ - You shuold extract it with "extract.exe". You can use
"more.exe" from DJG
Achilleas informed You very good. But if Your SQL file comes from other
DBMS, like MySQL, You have to a little bit to edit this file, becouse
sometimes in those files are used "slangs" characteristical for specific
DBMS.
If You have SQL file genarated with "pg_dump", You have to be sure, that
a
I've tried to do this same thing i "psql" client. It was worked properly.
I'm not sure, but maybe Your table on disk is corrupted.
Does it work simply:
select oid from public.lock
and
select * from public.lock
and
SELECT "oid", * FROM "public"."lock"
?
Your query will be faster makinkg it that way
Four thigs:
1. Do You have in "postgresql.conf" in section "CONNECION AND
AUTENTICATION" active opction (default is 'localhost'):
listen_adress='*' (if You want to be more safe, read PDF with PostgreSQL
doc chapter 17)
2. You're telneting 83.xxx.xxx.xxx, but You have 62.xxx.xxx.xxx in
pg_hba.co
I think it is not administration thing, but SQL language problem.
PostgreSQL is SQL92 compatible and has many very good and useful addons.
Generally, PostgreSQL gives You tools to analyze all, what You want,
when You hava data in tables.
You've explained in to short way You problem. The best is
There is no test, like in MySQL, for example.
If You've installed the "datasource", I suppose, You know the database,
server and other connection parameters.
You have ony way - to use any application, what can use "datasources",
for example Microsoft Office. If it's MS Proffesional (with MS Acce
Try (do not use ">" output stream redirection, but "-f" switch):
0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database -f
/usr/backup/friDATE4.pgdump
0 20 * * 4 pg_dump -F c database -f /usr/backup/thurDATE06-3.pgdump
Or instead (if it will not work):
1. Put those commands into root crontab file (/var
u (it was my
problem, not Yours ;-) ).
Greetings from Gdynia
Adam
Robin Iddon wrote:
Adam Radlowski wrote:
I can't find in the documentation, if it is possible to define our
own sort order for already compiled PostgreSQL.
I need it, because the best for my now building application were be
Run the "top" program. You'll see, that Your server CPU time is strongly
take by postmaster. The best way is to have two machines - servers: for
database server and for terminals. Maybe good will be to have more than
one CPU in the one server and run database server on CPU not used by
others ap
I can't find in the documentation, if it is possible to define our own
sort order for already compiled PostgreSQL.
I need it, because the best for my now building application were be to
build sort with normal LATIN2 sort order (for non alphanumeric chars
compatible with ASCII sort order).
I saw
21 matches
Mail list logo
