Dear Members!
Windows 10, PGSQL 9.4 and 9.6 (Debian with SSL, and Windows without it - it
doesn't matter).
When I (or my boss) work(s) at home, I got connection lost errors from
PGAdmin (3/4) or from other applications too.
server closed the connection unexpectedly
This probably means the
Hi!
Somebody wrote me that:
The pg_catalog schema is system schema, but it is IN the DB.
Is this true? So OID is not global (out from DB)?
So we can dump and restore the DB with OIDs without collision in new server?
Thank you!
dd
2017-10-12 11:35 GMT+02:00 Durumdara <durumd...@gmail.
Dear Members!
Because of upload/download progress we used LargeObjects to store some
files in one of our database (and not bytea).
Only this database uses the OID-s of these files.
In the near future we must move to another server.
This new server is also working now, the moving of databases is
Dear Members!
At Friday one of our clients got this error:
"cached plan must not change result type"
He restarted the application and the problem vanished.
We used PGDAC to access the database.
Firstly we didn't know nothing about this kind of error.
But later we realized that
Dear Members!
Windows Clients, PG 9.4 on Linux.
I used [PID + Client IP + Port + BackEnd Start] for unique identification
of a connection.
Every connection store it's unique connection info in a table (per
DataBase).
F.e:
"8574|195.12.4.3|50120|2017-01-01 08:12:15"
Yesterday I realized that
to the termination.
Thank you!
dd
2017-03-14 15:29 GMT+01:00 Melvin Davidson <melvin6...@gmail.com>:
>
>
> On Tue, Mar 14, 2017 at 10:15 AM, Durumdara <durumd...@gmail.com> wrote:
>
>> Dear Members!
>>
>> In a very strong Linux machine (with many 16-30 GB RAM) wha
Dear Members!
In a very strong Linux machine (with many 16-30 GB RAM) what is the limit
of the PGSQL server (9.4-9.5) "maximum connections"?
1000?
2000?
The clients are native applications (Windows executables) with persistent
connections, with more than 100 databases (every client have only
Hello!
Sorry, meanwhile I found it as Group Role.
I never used this kind of role. How to restore it to normal login role?
Thanks for it!
dd
2016-12-08 9:53 GMT+01:00 Durumdara <durumd...@gmail.com>:
> Dear PG Masters!
>
> In a server today I didn't find an important role.
>
Dear PG Masters!
In a server today I didn't find an important role.
I don't know what my colleagues did with it, but it seems to be lost.
Do you know a trick, how get info about it?
1.) Who dropped it?
2.) If not dropped what happened with it?
Does role dropping logged somewhere?
Thanks for
Dear Laurenz!
2016-11-07 16:06 GMT+01:00 Albe Laurenz <laurenz.a...@wien.gv.at>:
> Durumdara wrote:
> > Linux server, 9.4 PG, Windows clients far-far away.
> > May we must limit these parameters in clients after the starting of the
> connection?
>
> Don't both
Hello!
Linux server, 9.4 PG, Windows clients far-far away.
They called us that they had an "internet reset" at 13.00, but many client
locks are alive now (14:00).
I checked server status, and and saw 16 connections.
In Windows PG server I read about keepalive parameters which are control
and
Wow... I found it. The postgres database contained more
default privs. But PGAdmin III nothing say about dependents in it's reports.
Thanks!
2016-10-21 16:19 GMT+02:00 Durumdara <durumd...@gmail.com>:
> Dear Tom!
>
> Is there any tool what can show me
Dear Tom!
Is there any tool what can show me the dependents or dependencies?
In PGAdmin I don't see any dependencies or dependents... :-(
Thanks
dd
2016-10-21 16:08 GMT+02:00 Tom Lane <t...@sss.pgh.pa.us>:
> Durumdara <durumd...@gmail.com> writes:
> > The DB_X dropp
kground, I will
be in trouble...
Thanks
2016-10-21 15:27 GMT+02:00 Tom Lane <t...@sss.pgh.pa.us>:
> Durumdara <durumd...@gmail.com> writes:
> > We have a ROLE_MAIN.
> > This gave default privileges to all next objects in DB_X to ROLE_X.
> > Somebody dropped
Hello!
We created a DB named DB_X, and a role ROLE_X.
We have a ROLE_MAIN.
This gave default privileges to all next objects in DB_X to ROLE_X.
Somebody dropped DB_X, and later he tried to drop ROLE_X.
But he got errors in PGAdmin.
---
pgAdmin III
T+02:00 Albe Laurenz <laurenz.a...@wien.gv.at>:
> Durumdara wrote:
> [...]
> > --- login with postgres:
> [...]
> > ALTER DEFAULT PRIVILEGES
> > GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES,
> TRIGGER ON TABLES
> > TO u_
Dear Charles!
Sorry for late answer. Now I got a little time to check this again...
2016-09-14 18:43 GMT+02:00 Charles Clavadetscher :
> Hello
>
>
>
>
>
> Also try this:
>
>
>
> ALTER DEFAULT PRIVILEGES FOR ex_mainuser GRANT INSERT, SELECT, UPDATE,
> DELETE,
ainuser3 (id integer); commit;
-- login as ex_dbuser
-- select * from t_mainuser3; -- ERROR!
Thanks: dd
2016-09-14 16:52 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> On 09/14/2016 06:52 AM, Durumdara wrote:
>
>> Dear Charles!
>>
>>
>
>> I
Dear Charles!
I checked your solution. For example:
db - database
dbuser, mainuser
1. dbuser own the database, and the objects in it.
2. mainuser member of dbuser.
3. public connection revoked.
Ok.
Then dbuser can see all tables, and mainuser too.
Ok.
The operation (overlord):
1. set role to
Dear Everybody!
I read the documentation based on your example. First reactions.
2016-09-05 18:25 GMT+02:00 Charles Clavadetscher :
>
>> GRANT us_a, us_b, us_c TO main_admin;
>>
>
Ah, it's good. I can merge the "owner" rights to one. :-)
It's like "doubling"! :-)
Dear Everybody!
I'm sorry because lack of answer - I try to do it now.
2016-09-05 16:19 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> On 09/05/2016 05:45 AM, Durumdara wrote:
>
>> Dear PG-masters!
>>
>> We want to put more databases to one server, to
Dear PG-masters!
We want to put more databases to one server, to "public" schema:
DB_A, DB_B, DB_C.
And users:
US_A, US_B, US_C, and Main_Admin.
We want to setup the environment.
Every simple user can access his database:
DB_A - US_A
DB_B - US_B
DB_C - US_C
They can't access other databases only
Hello!
As I experienced, PGSQL changes the result field sizes to unlimited
varchar, when I passed different field size in same column of the union.
SP.Key - varchar(100)
SP.Value - varchar(200)
Example:
select 'a', value from sp
union all
select key, value from sp
The first field is
Dear All!
>In PG it's seems to be different. PG silently rollback the actual
> transaction.
>>
>
> I am not seeing silent:
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block
>
I say "silently", because first I didn't recognize that all things lost,
not
Dear All!
2016-04-10 18:03 GMT+02:00 Adrian Klaver :
> On 04/10/2016 06:29 AM, durumd...@gmail.com wrote:
>
>>
>> Products, offers are edited for long time.
>>
>
> Define long time, a session, a day, days, etc?
>
For 1 minute to 1-2 hours.
>
> But we must save
ike guid repetition). Yes, it have. And not the
BAD SYSADMIN, but the summer/winter time changes are dangerous (the
backward version). In PG we can extend our "guid" with IP and Port too, and
this could be enough safe for us.
Thanks
2016-04-09 16:05 GMT+02:00 Adrian Klaver <adrian.kla...@akla
her user!')
Thanks for your inspiration!
2016-04-09 12:30 GMT+02:00 John R Pierce <pie...@hogranch.com>:
> On 4/9/2016 1:30 AM, Durumdara wrote:
>
>> In MS we had...
>>
>
> If you want Microsoft's unique version of SQL, run Microsoft SQL. That
> stuff you
Dear Everybody!
In MS we had a "persistent lock" structure and method.
This over transactions because based on real records in a real table with
pri key (tablename + id).
For garbaging we had a special session info.
In MS the session id is smallint, so it can repeats after server restarts,
but
Dear PG Masters!
As I experienced I can create normal and temp table with same name.
create table x (kod integer);
CREATE TEMPORARY TABLE x (kod integer);
select tablename from pg_tables where schemaname='public'
union all
select c.relname from pg_class c
join pg_namespace n on
Dear Everybody!
Can somebody show me an example for phantom read in Repeatable Read mode
(in 9.1, new, serialized kind of isolation level)?
The help wrote that it is possible:
Repeatable read Not possible Not possible Possible
But I don't understand, why, and how.
C1, C2 are clients.
Every of
is also showing one tx state/statement per connection)
So if I want to make two transactions in client am I must duplify the
connections in this period?
Thanks for your help:
dd
2012/2/17 Durumdara durumd...@gmail.com:
Dear PGSQL Masters!
What do you thinking about this? Can I do this without
Hi!
In FireBird I can set the transaction to nowait.
When I want to protect a row for long time (showing a dialog, and on
closing I release the row), I need to do this:
trans.StartTransaction();
sql.execute('update thetable set afield = afield where idfield = anyvalue');
This is locking the row
Dear Filip!
2012/2/28 Filip Rembiałkowski plk.zu...@gmail.com:
On Tue, Feb 28, 2012 at 10:26 AM, Durumdara durumd...@gmail.com wrote:
Just some loose comments.
http://www.postgresql.org/docs/current/static/explicit-locking.html#LOCKING-ROWS
A way to explicitly lock given row without
Hi!
We planned to port some very old DBASE db into PGSQL.
But somebody said in a developer list that he tried with PGSQL (8.x) and it
was very unstable in Windows (and it have problem when many users use it).
Another people also said that they used PGSQL only in Linux - and there is
no problem
Hi!
2012/2/24 mgo...@isstrucksoftware.net
We are using it on a rather beefy server with no problems with a Win32
client/server app.
Which programming language you use in clients? Which adapter?
If Delphi then which components?
There are additonal things you can do to tune the
database.
Dear PGSQL Masters!
I got a new project: porting a DBASE based application to PGSQL. Some
theoretic question I have before I coding/typing.
OS: Win, IDE: Delphi.
Preface:
Delphi uses TDataSet-s (every of them have records/rows).
When use Post method to save the actual record. In DBASE or flat
Dear PGSQL Masters!
I have a complicated question.
Is there any way to extend the session information (what visible in
pgadmin's Server Status)?
I explain what I want to do:
We used alternative DB in a place and I need to port this.
In this DB we using different db users for every real users.
Hi!
2012/1/31 Guillaume Lelarge guilla...@lelarge.info
On Tue, 2012-01-31 at 04:16 -0800, durumdara wrote:
Dear PGSQL Masters!
I have a complicated question.
Is there any way to extend the session information (what visible in
pgadmin's Server Status)?
I explain what I want to do
Hi!
2011/7/4 Craig Ringer cr...@postnewspapers.com.au:
On 4/07/2011 7:50 PM, Durumdara wrote:
As I understand you then running Queries forced to abort on the end of
Session and no more Query running over the session's ending point (or
after TCP connection broken).
Correct. The server might
Hi!
2011/7/6 Durumdara durumd...@gmail.com:
Most importantly, PostgreSQL's stored procedures cannot control
transactions. They cannot commit, rollback, or begin a new transaction. They
have some control over subtransactions using PL/PgSQL exceptions, but that's
about it.
So: I tried it, I
the connection. For example: every 1 minutes we do some
dummy thing one server, like select date or etc.
The reflections:
2011/6/30 Bill Moran wmo...@potentialtech.com:
In response to Durumdara durumd...@gmail.com:
Hi!
2011/6/30 Bill Moran wmo...@potentialtech.com:
In response to Durumdara
Hi!
2011/7/4 Vincent de Phily vincent.deph...@mobile-devices.fr:
On Monday 04 July 2011 10:48:48 Durumdara wrote:
1.) DataBases need to close the resources kept by Sessions.
2.) There is need some border, or a rule to split - which Session is
considered as finished.
So far so good.
...so
Ahoj!
2011/7/4 Vincent de Phily vincent.deph...@mobile-devices.fr:
On Monday 04 July 2011 12:49:24 Durumdara wrote:
What happens with running statements and stored procs at Session's end?
They will be aborted and destroyed, or they can continue the running?
For example:
User X starts
Hi!
I asked same thing in the list formerly,
http://archives.postgresql.org/pgsql-general/2011-06/msg00888.php
And because of lack of answers now I asked here also:
http://stackoverflow.com/questions/6534654/postgresql-session-timeout
I'm very wondering that I don't (and can't) found a system
Hi!
2011/6/30 Bill Moran wmo...@potentialtech.com:
In response to Durumdara durumd...@gmail.com:
Session ends when the connection is terminated. I.e., a PostgreSQL
session is synonymous with a TCP connection (or domain socket in some
cases).
In Windows OS what's this meaning?
I know
Hi!
I want to ask that what happens if a long query running and user session
timeout reached?
1.)
For example: somebody starts a very long query or statistical stored
procedure.
The session timeout is 5 minutes, and the session exhausted this time.
What happens?
a.)
The Query/STP
Hi!
I have 3 tables. I want to run a query that collect some data from
them, and join into one result table.
I show a little example, how to do this in another DB with script:
create temp table tmp_a as select id, name, sum(cost) cost from items
where... group by id, name with data;
create
Hi!
In Firebird the transaction can be parameterizable as:
SET TRANSACTION
...
[WAIT | NO WAIT]
[LOCK TIMEOUT seconds]
The NO WAIT is force transaction to return instantly with errormsg
when some deadlock situation happened, Timeout is define the seconds
for wait.
This can be set for
Hi!
Is there any function in PGSQL that returns an unique Session
identifier of the actual session?
For example a Bigint, or GUID, or etc?
Can I get the living Session identifiers from PG?
We have a little application that uses these infos which are basically
came from another database system,
Hi!
2011/5/12 Albe Laurenz laurenz.a...@wien.gv.at:
Durumdara wrote:
Two table:
Main
Lookup
The query is:
select Main.*, Lookup.Name
left join Lookup on (Main.Type_ID = Lookup.ID)
hat's not correct SQL, but I think I understand what you mean.
Sorry, the from is missed here... :-(
Lookup
Hi!
Two table:
Main
Lookup
The query is:
select Main.*, Lookup.Name
left join Lookup on (Main.Type_ID = Lookup.ID)
Lookup:
ID Name
1 Value1
2 Value 2
3 Value 3
Many records is in Main table (for example 1 million).
What happens in this case (C = connection):
C1.) begin read committed
C1.)
Hi!
We will porting an application to PGSQL from some table based app (BDE
like).
The older application used a special technic of the driver: if a record
edited, some exclusive (over transaction), forever living lock put on it.
On exit, cancel, or post this lock removed.
We used this to
Dear Everybody!
I want to ask that have some way to install PGSQL 9.0 as two instances
in one machine?
Most important question. The OS is can be Windows or Linux.
I asked this, because formerly we heard about a story. I cite this as I
remember:
We have some product, and in the only
Hi!
Windows 7x64, PG9.0, PGAdmin 1.12.1.
First I sent this problem to PGADMIN support list, you can see it, but
I repeat the description.
http://archives.postgresql.org/pgadmin-support/2011-04/msg00012.php
I tried to fillup a text field with all ANSI characters
chr(1)..chr(255). Except 0
Hi!
PG9.0, Delphi 6, Zeos.
I want to use PGSQL bytea field as normal BLOB field in Delphi.
But when I insert a value into this field, for example all characters (chr
0..255), and I fetch, and save it as blob stream into a file, I got
interesting result, not what I stored here previously.
It is
at 8:54 PM, Durumdara durumd...@gmail.com
mailto:durumd...@gmail.com wrote:
Hi!
I want to migrate some database to PG.
I want to make intelligens migrator, that makes the list of the
SQL-s what need to do to get same table structure in PG as in the
Source DB.
All things I
Hi!
I want to migrate some database to PG.
I want to make intelligens migrator, that makes the list of the SQL-s what
need to do to get same table structure in PG as in the Source DB.
All things I can get from the views about tables, except the indices.
These indices are not containing the
Dear Everybody!
We need to choice a DB for our new project.
Two of the databases are possible to choose.
1.) PGSQL 9.x
2.) FireBird 2.x
We needs to serve 75/80 users in a time.
The client platform is Windows, Delphi based applications with [Zeos/PGDAC]
or [IBX/ZEOS].
The server is may Windows,
Hi!
Many databases (like Firebird) have some time limitation for the clients.
These cases possible with client:
a.) It is working, but network connection is temp. down.
b.) The client is crashing
c.) The client is on, but it is not working for N minutes.
When the server experience that client
Hi!
In other RDBMS I found a way to make dynamic statements.
I can use variables, or concat the SQL segments, and execute it all.
:tablename = call CreateTempTable;
insert into :tablename
drop table :tablename
or (FireBird like cursor handling):
sql = select * from || :tablename ||
update :tbl set sumof = :sumof where part_id=:part_id
end;
Can you show me same example?
Thanks:
dd
2011/3/7 Adrian Klaver adrian.kla...@gmail.com
On Monday, March 07, 2011 6:32:44 am Durumdara wrote:
Hi!
In other RDBMS I found a way to make dynamic statements.
I can use variables
Hi!
PG8,4, Window XP, Python.
I have a program that makes many picture version from an original with
XNView effects.
Because I want preserve the integrity, previous datas, I used transactions,
and PGSQL.
The main problem with blobs that insertion is good, the select is good, but
the deletion is
Hi!
I want to ask about PGSQL-crack/hack-web-database.
So:
We have a web site with python. The DB engine is PGSQL.
The first theory was that PGSQL is locally used, and each of other
operations are realized with encoded XML packages.
These operations are: fill up partner data, fill up offer
Hi!
2009/12/19 Albe Laurenz laurenz.a...@wien.gv.at
If you need the data in WIN1250 on the client side, change the client
encoding to WIN1250.
So:
- Create the database with UTF8.
- Change the client encoding to WIN1250 (e.g. by setting the environment
variable PGCLIENTENCODING).
-
Hi!
2009/12/21 Albe Laurenz laurenz.a...@wien.gv.at
Durumdara wrote:
- Change the client encoding to WIN1250 (e.g. by
setting the environment variable PGCLIENTENCODING).
So if I have Python and pygresql, can I set this value in Python?
The main problem that I don't want to set
Hi!
I have a software that uses Postgresql. This program (and website) developed
and working on Window (XP/2003), with native charset (win1250).
Prior week we got a special request to install this software to a Linux
server.
Yesterday I installed Ubu9.10 on VirtualBox, and tried to moving the
Hi!
I must get informations about the tables.
For example:
Tnnn:
1. [Field Name, Type, Size, NotNull]
2. [Field Name, Type, Size, NotNull]
...
The test table is this:
CREATE TABLE testfields
(
fbigint bigint NOT NULL,
fbool boolean,
fchar character(100),
fcharv character varying(100),
Hi!
select * from any where is_deleted = Null
select * from any where is_deleted in (Null)
They are show 0 record.
select * from any where is_deleted is Null
It is show all records.
Some of other DBs are uses Null as Null in = comparisons. Is PG not? What
are the rules?
Thanks: dd
) thread actually read the rows that they are want to modify?
This is the main question about it.
Thanks for your read/answer!
dd
2009.07.07. 11:36 keltezéssel, Albe Laurenz írta:
Durumdara wrote:
Please send me an example (pseudo-code) for Serializable conflict.
And I wanna know
Hi!
Please send me an example (pseudo-code) for Serializable conflict.
And I wanna know, if possible, that if more transactions only read the
tables in Serializable mode, and one or others write to it, can I got some
conflicts in read operation?
c = client t = transaction
c1t1 begin serial
c1t1
Hi!
2009.07.01. 9:43 keltezéssel, Craig Ringer írta:
On Wed, 2009-07-01 at 09:23 +0200, durumdara wrote:
Firebird have repeatable read, but PG is not have it. Hmmm... Then that is
meaning that every statement is in new
transaction context which can makes inconsistency in the views
Hi!
2009.06.29. 18:26 keltezéssel, Craig Ringer írta:
On Mon, 2009-06-29 at 13:36 +0200, durumdara wrote:
I wanna ask something. I came from IB/FB world.
InterBase / FireBird ?
Yes, sorry for short descriptions.
In this world I was everytime in transaction, because
Hi!
2009.06.29. 15:34 keltezéssel, A. Kretschmer írta:
In response to durumdara :
Hi!
Can I check with something that I'm in in-transaction or in autocommit
mode?
I wanna avoid the notices I got when I'm also in mode I need...
For example:
begin
begin --- error notice...
Warning
Hi!
I wanna ask something. I came from IB/FB world.
In this world I was everytime in transaction, because of reads are also
working under transactions.
In the FB world the transactions without any writes/updates are not
locking the database, so another clients can makes a transactions on any
Hi!
Can I check with something that I'm in in-transaction or in autocommit
mode?
I wanna avoid the notices I got when I'm also in mode I need...
For example:
begin
begin --- error notice...
Thanks for your help:
dd
ps: in my prev. mail I asked this too, but in another context...
possible
Hi!
In FireBird the transactions have these settings:
SET TRANSACTION
[NAME/|hostvar|/]
[READ WRITE | READ ONLY]
[ [ISOLATION LEVEL] { SNAPSHOT [TABLE STABILITY]
| READ COMMITTED [[NO] RECORD_VERSION] } ]
[WAIT | NO WAIT]
[LOCK TIMEOUT/|seconds|/]
And
Hi!
2009.05.06. 11:54 keltezéssel, Richard Huxton írta:
durumdara wrote:
So: have PGSQL same mechanism like nowait?
When you take a lock:
http://www.postgresql.org/docs/8.3/interactive/sql-lock.html
http://www.postgresql.org/docs/8.3/interactive/sql-select.html#SQL-FOR-UPDATE-SHARE
As I
Hi!
In a mod_py application I wanna write a wrapper that handle all PSQL
data view with paging/slicing.
For example:
I have 1.500 records. I wanna show only N (f. ex: 15) records in the
view, other records are accessable with a pager (links):
[First, P-2, P-1, P, P+1 P+2, Last]
F. Ex:
Hi!
2009.04.23. 9:23 keltezéssel, John R Pierce írta:
durumdara wrote:
Hi!
In a mod_py application I wanna write a wrapper that handle all PSQL
data view with paging/slicing.
..
Inserts all records to a temp table.
Check the affected rows (as count).
Slicing the records.
Fetch the slice
Hi!
Windows Server, PGSQL.
When a new records arrived to the database, I want process them in the
background.
I have a processor service.
This is periodically (5-10 minutes) checking the message table, and if
there is some message, it is process them.
This periodic processing is good, but
Hi!
I wanna ask, that have the PGAdmin same possibility (like in SQLyog) to
copy records (from the Query, from the Table View) to clipboard in the
INSERT SQL format?
This can speed up the work, and I can insert the record to another table
that have similar (but a little different) format
Hi!
Please help me a little.
I used PGAdmin to administrate my databases.
I created a new user named zx.
CREATE ROLE zx LOGIN
ENCRYPTED PASSWORD '*'
NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;
When I want to manually assign this user to a table, I have problem in
the PGAdmin's
Hi!
2009.01.31. 10:13 keltezéssel, Erik Jones írta:
On Jan 30, 2009, at 11:37 AM, durumdara wrote:
The main viewpoints:
- quick (re)connect - because mod_python basically not store the
database connections persistently
mod_python is not a database adaptor.
Yes, I know. But because
Dear PG Users!
I don't want to make a heated debate
http://szotar.sztaki.hu/dict_search.php?M=1O=HUNE=1C=1A=0S=HT=1D=0G=0P=0F=0MR=100orig_lang=HUN%3AENG%3AEngHunDictorig_mode=1orig_word=vitaflash=sid=0ab237888b26676a51a7567bf8920f92vk=L=ENG%3AHUN%3AEngHunDictW=heated%20debate
with this
Hi!
I came from SQLite, FireBird and DBISAM world.
These database systems have a speciality that they stores one database in
one file, or in one directory.
Each of databases have separated file (or dir with files), and when I want
to copy a database, I have MORE possibility to do this.
First
85 matches
Mail list logo