Re: Restore database into azure PostgreSQL

2019-07-11 Thread Adrian Klaver
nection on port 5432? Connection troubleshooting: 1) Verify Postgres server is actually running. 2) Verify what port it is listening on(5432 is default). 3) Verify correct hostname. 4) Check to see if there is a firewall blocking the Postgres server port. Thanks Mahesh Ravilla -- Adr

Re: Postgresql and VBA - Connection Timeout

2019-07-11 Thread Adrian Klaver
psqlODBC driver that I have the 30 second timeout limit. Has anyone found a way to make this work?  Thanks. https://www.postgresql-archive.org/BUG-odbc-statement-timeout-gets-set-to-3-td5992591.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgresql and VBA - Connection Timeout

2019-07-11 Thread Adrian Klaver
ver on the -odbc list: https://www.postgresql.org/list/pgsql-odbc/ could help. -- Adrian Klaver adrian.kla...@aklaver.com

Re: disable and enable trigger all when a foreign keys

2019-07-12 Thread Adrian Klaver
the triggers are not executed." Still it has caught me before and I would be interested in knowing why the difference? regards, tom lane [1] The general assumption in PG is that superusers know what they're doing. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

2019-07-12 Thread Adrian Klaver
formation. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Compiling table_log for PG 11 / attisdropped

2019-07-12 Thread Adrian Klaver
m By and for non-profits /http://agency-software.org// /https://demo.agency-software.org/client/ ken.tan...@agency-software.org <mailto:ken.tan...@agency-software.org> (253) 245-3801 Subscribe to the mailing list <mailto:agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

2019-07-13 Thread Adrian Klaver
where is the source for this fabled "postgresql-check-db-dir"? https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/9.2/postgresql/EL-7/postgresql92-check-db-dir;h=550b31770cabacf32cbb1b8f272e8ce305fc9908;hb=HEAD Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com

Re: how to execute pgsql2shp exe in sql

2019-07-14 Thread Adrian Klaver
nnects directly to the database and converts a table (possibly defined by a query) into a shape file. The basic syntax is: ... thanks peng -- Adrian Klaver adrian.kla...@aklaver.com

Re: after restore the size of the database is increased

2019-07-15 Thread Adrian Klaver
e | 2688193183 What does \l+ show? % psql -c 'select version();' -U postgres template1 version - PostgreSQL 11.3 on amd64-portbld-freebsd12.0, compiled by FreeBSD clang version 6.0.1 (tags/RELEASE_601/final 335540) (based on LLVM 6.0.1), 64-bit (1 row) -- Adrian Klaver adrian.kla...@aklaver.com

Re: Tablespace column value null on select * from pg_tables

2019-07-15 Thread Adrian Klaver
ve two commands (3rd will be moving indexes) run the query again and verify everything has moved from data2 to pg_default. Thanks for your help in advance. Alex Sent with ProtonMail <https://protonmail.com> Secure Email. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Tablespace column value null on select * from pg_tables

2019-07-15 Thread Adrian Klaver
27;t provide the correct named tablespace. It is probably doing something like: SELECT datname, spcname FROM pg_database AS pd JOIN pg_tablespace AS pt ON pd.dattablespace = pt.oid; Thanks, Alex Sent with ProtonMail Secure Email. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Removing a key from jsonb is sloooow

2019-07-17 Thread Adrian Klaver
rojects set misc = misc - 'foo'; Time: 324711.960 ms (05:24.712) What can I do to improve this? Provide some useful information: 1) Postgres version 2) Table schema 3) Explain analyze of query -- Adrian Klaver adrian.kla...@aklaver.com

Re: Removing a key from jsonb is sloooow

2019-07-17 Thread Adrian Klaver
on projects  (cost=0.00..4240.93 rows=10314 width=1149) (actual time=1.011..266.435 rows=10314 loops=1) Planning time: 40.087 ms Trigger trigger_populate_tsv_body_on_projects: time=341202.492 calls=10314 Execution time: 346320.260 ms Time: 345969.035 ms (05:45.969) On Wed, Jul 17, 2019 at

Re: Removing a key from jsonb is sloooow

2019-07-17 Thread Adrian Klaver
) Planning time: 40.087 ms Trigger trigger_populate_tsv_body_on_projects: time=341202.492 calls=10314 Execution time: 346320.260 ms Time: 345969.035 ms (05:45.969) On Wed, Jul 17, 2019 at 10:39 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 7/17/19 7:30 AM, Vol

Re: Looking for Postgres upgrade Metrix

2019-07-17 Thread Adrian Klaver
any lower version to Higher version. As long as you use the newer pg_dump to dump the older version. Please correct me if I am wrong. Thanks, Raj -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgers 9.3 - ubuntu 16.04 - Are clogs entires automatically deleted?

2019-07-18 Thread Adrian Klaver
even when they are still in use? Cristiano -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQL as a Service

2019-07-18 Thread Adrian Klaver
mpetitive means being able to match that. Thanks for any thoughts and opinions! Dirk -- Adrian Klaver adrian.kla...@aklaver.com

Re: PostgreSQL as a Service

2019-07-18 Thread Adrian Klaver
On 7/18/19 9:06 AM, Dirk Riehle wrote: Please reply to list also. Ccing list. On Thu, Jul 18, 2019, 16:56 Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: > So, back to my main question above. If I wanted to run a DBaaS shop with > only PostgreSQL open

Re: Possible Values of Command Tag in PG Log file

2019-07-18 Thread Adrian Klaver
have received this communication in error, please erase all copies of the message and its attachments and notify the sender immediately. Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Possible Values of Command Tag in PG Log file

2019-07-18 Thread Adrian Klaver
  command_tag  authentication (5 rows) Regads, Virendra -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>] Sent: Thursday, July 18, 2019 4:55 PM To: Kumar, V

Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6

2019-07-23 Thread Adrian Klaver
r.log" -D "/data/db/data" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start > Failure, exiting Is /var/lib/pgsql directory on the system? Can you start the instance with the above command? Luca -- Adrian Klaver adrian.kla...@aklaver.com

Re: Default ordering option

2019-07-23 Thread Adrian Klaver
select * from t1 ; a |b ---+- 2 | cat 3 | fish 1 | dogfish (3 rows) An UPDATE reorders the rows. Maybe throw an UPDATE into the test after creating the users to force an 'out of order' result? Thanks, Cyril -- Adrian Klaver adrian.kla...@aklaver.com

Re: Too slow to create new schema and their tables, functions, triggers.

2019-07-23 Thread Adrian Klaver
? I´m almost sure about. What do I need do to run my script as before ? Do I need to Reindex ? Vacuum ? Or am I reaching a limit in a number of schemas in a Postgres database ? -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
s in advance for the help.       Sergey -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote: On 7/23/19 3:19 PM, Sergey Koposov wrote: Hi, I'm trying to copy a schema from one PG database (ver 11) to PG 10. Previously the first database version was 9.6 and the way I did the copyin

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 3:42 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote: On 7/23/19 3:19 PM, Sergey Koposov wrote: Hi, I'm trying to copy a schema from o

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 3:58 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote: On 7/23/19 3:42 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 4:04 PM, Adrian Klaver wrote: On 7/23/19 3:58 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote: On 7/23/19 3:42 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
he last paragraph.        S         S -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
the permissions on the objects.       S -- Adrian Klaver adrian.kla...@aklaver.com

Re: Default ordering option

2019-07-24 Thread Adrian Klaver
second queries e.g. ROLLBACK? And for the other suggestion, I cannot blindly add 'ORDER BY random()' to every select, because of the incompatibility with distinct and union, and the way we use our orm. Are you talking about the production or test queries above? -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgres 9.5 DB corruption

2019-07-24 Thread Adrian Klaver
at postgres.c:4049 #14 0x080b53af in BackendRun (port=0xa584b78) at postmaster.c:4312 #15 BackendStartup (port=0xa584b78) at postmaster.c:3986 #16 ServerLoop () at postmaster.c:1705 #17 0x082d0dd7 in PostmasterMain (argc=argc@entry=3, argv=argv@entry=0xa53d2a8) at postmaster.c:1313 #18 0x080b68eb in main

Re: postgres 9.5 DB corruption

2019-07-24 Thread Adrian Klaver
an that to include associated schema like triggers, constraints, etc. Basically what is returned by \d in psql. Tom    :-) -- Adrian Klaver adrian.kla...@aklaver.com

Re: Default ordering option

2019-07-24 Thread Adrian Klaver
affected by an order by in any case as the count() would be the same: "select count(*) from (#{directory_doctors_query_sql} union all #{profiles_query_sql}) as doctors" If you did want to use order by random() could you not just tack it on the end?: "... as doctors order

Re: Running concurrent txns and measuring the timings in Postgres

2019-07-24 Thread Adrian Klaver
txns till the end of the last txn. It would help to know what problem you are trying to solve? Best, -SB -- Adrian Klaver adrian.kla...@aklaver.com

Re: Too slow to create new schema and their tables, functions, triggers.

2019-07-24 Thread Adrian Klaver
´ll try just reindexing system before adding a new schema to see if it works. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Running concurrent txns and measuring the timings in Postgres

2019-07-24 Thread Adrian Klaver
inning of the transactions and the end and record that somewhere(db table and/or file)? On Wed, Jul 24, 2019 at 1:58 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 7/24/19 9:54 AM, Souvik Bhattacherjee wrote: > Hi, > > Is there a standard p

Re: Running concurrent txns and measuring the timings in Postgres

2019-07-24 Thread Adrian Klaver
at client(s) you are using and how the transactions are being generated? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Running concurrent txns and measuring the timings in Postgres

2019-07-24 Thread Adrian Klaver
l file and are fired from different psql sessions, if that helps. A quick demo: psql -d production -U postgres -c "\timing" -c "select line_id, category from avail_headers order by line_id;" Timing is on. Time: 0.710 ms On Wed, Jul 24, 2019 at 4:44 PM Adrian

Re: Running concurrent txns and measuring the timings in Postgres

2019-07-24 Thread Adrian Klaver
ed to comment, but on the surface it looks good to me. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Default ordering option

2019-07-25 Thread Adrian Klaver
> > I would like to know if there is any way to change that to have a "real" > random behaviour. It might be an interesting exercise to implement this as a post-parsing hook. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Adrian Klaver adrian.kla...@aklaver.com

Re: SELECT INTO question

2019-07-25 Thread Adrian Klaver
used. " So: test=# \d t2 Table "public.t2" Column | Type | Collation | Nullable | Default +--+---+--+- Thanks, Kevin -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgres 9.5 DB corruption

2019-07-25 Thread Adrian Klaver
'_ams_cluster', '2', 'kk') _ams_cluster_truncatetrigger BEFORE TRUNCATE ON ams.alert_attribute FOR EACH STATEMENT EXECUTE PROCEDURE _ams_cluster.log_truncate('2') Disabled user triggers: _ams_cluster_denyaccess BEFORE INSERT OR DELETE OR UPDATE ON ams.alert_att

Re: Too slow to create new schema and their tables, functions, triggers.

2019-07-25 Thread Adrian Klaver
ve to the list. Also the setting for track_counts. And again, if I do a Reindex database before creating that schema, it works perfectly. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Too slow to create new schema and their tables, functions, triggers.

2019-07-25 Thread Adrian Klaver
On 7/25/19 4:01 PM, PegoraroF10 wrote: Nope, no one message near those statements. I haven´t changed anything on Postgres.conf related with autovacuum. So what are the settings? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Too slow to create new schema and their tables, functions, triggers.

2019-07-25 Thread Adrian Klaver
what autovacuum activity has occurred on the tables. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Too slow to create new schema and their tables, functions, triggers.

2019-07-26 Thread Adrian Klaver
there. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Tablespace column value null on select * from pg_tables

2019-07-28 Thread Adrian Klaver
target directory, i.e., objects of * this database that are already in the target tablespace. We can't * allow the move in such a case, because we would need to change those * relations' pg_class.reltablespace entries to zero, and we don't have * access to the DB's pg_class to do

Re: Reproducing query plans in empty database: can I just copy stats and settings?

2019-07-29 Thread Adrian Klaver
going to help. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Reproducing query plans in empty database: can I just copy stats and settings?

2019-07-29 Thread Adrian Klaver
On 7/29/19 3:08 PM, Tom Lane wrote: Guyren Howe writes: On Jul 29, 2019, at 12:25 , Adrian Klaver wrote: If you can't see/use the data in the production database in your test database I'm not sure how copying the statistics/cost settings is going to help. Isn’t that the entire

Re: adding more space to the existing server

2019-08-01 Thread Adrian Klaver
it is 97% full (PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.3.1-14ubuntu2) 5.3.1 20160413, 64-bit) Thank you for your suggestions -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGAdmin4.11.1 on Ubuntu 18.04

2019-08-01 Thread Adrian Klaver
installed as part of the dtsutils package along with pgadmin4. I'm not following. If is installed as part of pgAdmin4 why do you need to upgrade? | |Any ideas? | -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGAdmin4.11.1 on Ubuntu 18.04

2019-08-01 Thread Adrian Klaver
t's installed as part of the dtsutils package along with pgadmin4. | |Any ideas? | -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGAdmin4.11.1 on Ubuntu 18.04

2019-08-01 Thread Adrian Klaver
;m assuming) is: http://initd.org/psycopg/articles/2019/04/04/psycopg-28-released/ "Added table_oid and table_column attributes on cursor.description items (ticket #661)." Have you looked at: ~/.config/pgadmin/pgadmin4.conf to see what it is using as PythonPath? -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGAdmin4.11.1 on Ubuntu 18.04

2019-08-01 Thread Adrian Klaver
you getting the packages from? -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGAdmin4.11.1 on Ubuntu 18.04

2019-08-01 Thread Adrian Klaver
ill be updating issue. -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGAdmin4.11.1 on Ubuntu 18.04

2019-08-01 Thread Adrian Klaver
On 8/1/19 9:05 AM, Daniele Varrazzo wrote: On Thu, Aug 1, 2019 at 4:43 PM Adrian Klaver wrote: Yeah the requirements file shows psycopg2-2.8: https://github.com/postgres/pgadmin4/blob/master/requirements.txt The issue(I'm assuming) is: http://initd.org/psycopg/articles/2019/04/04/psyco

Re: adding more space to the existing server

2019-08-02 Thread Adrian Klaver
their own standbys. This solution requires breaking up existing replication as well. Can you please point me to some document which lists all steps describing breaking up the existing replication properly? we are using 9.6 postgres Thank you! -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to check if a field exists in NEW in trigger

2019-08-04 Thread Adrian Klaver
w.postgresql.org/docs/11/catalog-pg-attribute.html Or use the columns information_schema: https://www.postgresql.org/docs/11/infoschema-columns.html Any ideas?  Thanks! Igal Sapir Lucee Core Developer Lucee.org <http://lucee.org/> -- Adrian Klaver adrian.kla...@aklaver.com

Re: Does pgadmin4 work with postgresql 8.4?

2019-08-05 Thread Adrian Klaver
connection to the 8.4 instance and see if it works:) Thanks, ~Ben -- Adrian Klaver adrian.kla...@aklaver.com

Re: Does pgadmin4 work with postgresql 8.4?

2019-08-05 Thread Adrian Klaver
rg/list/pgadmin-support/ Thanks, ~Ben On Mon, Aug 5, 2019, 4:48 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 8/5/19 1:15 PM, Benedict Holland wrote: > The subject says it all. I am using a very old database that I cant > upgrade. Do I have to manage

Re: Does pgadmin4 work with postgresql 8.4?

2019-08-05 Thread Adrian Klaver
a very old database that I cant upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4? Thanks, ~Ben -- Adrian Klaver adrian.kla...@aklaver.com

Re: Does pgadmin4 work with postgresql 8.4?

2019-08-06 Thread Adrian Klaver
On 8/5/19 10:02 PM, Murtuza Zabuawala wrote: On Tue, Aug 6, 2019 at 7:57 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 8/5/19 7:04 PM, Murtuza Zabuawala wrote: > No, pgAdmin4 only supports PostgreSQL 9.2 and later versions. Where is that ment

Re: Does pgadmin4 work with postgresql 8.4?

2019-08-06 Thread Adrian Klaver
t you gotta do. Good luck, Luca -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?

2019-08-06 Thread Adrian Klaver
lback you get the error. REMEMBER in plpgsql Begin is not for transaction control: https://www.postgresql.org/docs/11/plpgsql-transactions.html Have not worked through the second case yet. . -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?

2019-08-07 Thread Adrian Klaver
rt of moot as PROCEDURE is a Postgres feature not a company feature. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Input validation

2019-08-07 Thread Adrian Klaver
, before allowing the new record to be inserted. Any thoughts as to good way to do this? INSERT UPDATE trigger: https://www.postgresql.org/docs/11/sql-createtrigger.html https://www.postgresql.org/docs/11/plpgsql-trigger.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?

2019-08-07 Thread Adrian Klaver
hen things become clearer. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Recomended front ends?

2019-08-07 Thread Adrian Klaver
u are comfortable with. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?

2019-08-07 Thread Adrian Klaver
tStatus(results) != PGRES_COMMAND_OK) ... psycopg2: https://github.com/psycopg/psycopg2/blob/master/psycopg/connection_int.c ~line 1294 On 07-Aug-2019, at 11:56, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 8/7/19 11:46 AM, Bryn Llewellyn wrote: Thanks for your response

Re: Recomended front ends?

2019-08-08 Thread Adrian Klaver
d.  The downside was having to program in VBA but things may be much better these days with .NET et.al. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Recomended front ends?

2019-08-08 Thread Adrian Klaver
time soon. Regards, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?

2019-08-08 Thread Adrian Klaver
it, as you do in some of your previous messages. It should be stressed that Autocommit is not a parameter of the session between Postgres and the SQL client, but rather it's a parameter of the session between the user and their SQL client. So when you're hypothesizing that a plpgsql block in a procedure would look at this parameter or change it temporarily (your points #2 and #5 in your analysis of p2's execution), you should see that it's impossible, because on the server-side, this parameter just does not exist. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Adrian Klaver adrian.kla...@aklaver.com

Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
you are trying to achieve? 4) What techniques have you tried? 5) If you need only 1GB why the 400GB number? Thanks. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Understanding PostgreSQL installer debug log

2019-08-09 Thread Adrian Klaver
your insight. -- Ramesh -- Adrian Klaver adrian.kla...@aklaver.com

Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
On 8/9/19 8:14 AM, Shital A wrote: On Fri, 9 Aug 2019, 20:08 Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote: On 8/9/19 4:12 AM, Shital A wrote: > Hello > > Postgresql 9.6 > > Need to generate 1GB test data in very less time. I

Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
some_table -a -f test_data.sql That will dump the data only for the table in COPY format. Then you could apply that to your test database(after TRUNCATE on table, assuming you want to start fresh): psql -d test_db -f test_data.sql -- Adrian Klaver adrian.kla...@aklaver.com

Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
On 8/9/19 9:51 AM, Shital A wrote: On Fri, 9 Aug 2019, 21:25 Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote: On 8/9/19 8:14 AM, Shital A wrote: > > Hello, > > 4) What techniques have you tried? > Insert into with With statement

Re: Bulk Inserts

2019-08-09 Thread Adrian Klaver
r you. Best, -SB -- Adrian Klaver adrian.kla...@aklaver.com

Re: Bulk Inserts

2019-08-11 Thread Adrian Klaver
for id in val_batch: insert into tab2 (attr1, attr2) (select attr1, attr2 from tab1 where attr2 = id) COMMIT Best, -SB -- Adrian Klaver adrian.kla...@aklaver.com

Re: constrain with MATCH full and NULL values in referenced table

2019-08-12 Thread Adrian Klaver
reject an entry if one, or both of the 2 key values being inserted in the table are NULLS,. -- Adrian Klaver adrian.kla...@aklaver.com

Re: constrain with MATCH full and NULL values in referenced table

2019-08-12 Thread Adrian Klaver
On 8/12/19 8:51 AM, stan wrote: Please reply to list also. Ccing list. On Mon, Aug 12, 2019 at 08:17:33AM -0700, Adrian Klaver wrote: On 8/12/19 8:11 AM, stan wrote: I am creating a table that has 2 values in it which are keys pointing to 2 other tables. I need for the UNIQUE combination of

Re: Subject: Re: constrain with MATCH full and NULL values in referenced table

2019-08-12 Thread Adrian Klaver
_key) references work_type(work_type_key) , ^ FOREIGN KEY (work_type_key , employee_key) REFERENCES rate (work_type_key , employee_key) MATCH FULL They are covered above. ); -- Adrian Klaver adrian.kla...@aklaver.com

Re: Subject: Re: constrain with MATCH full and NULL values in referenced table

2019-08-12 Thread Adrian Klaver
record in task_instance until a record exists in rate. 3) 2) means you have already established a relationship to employee and work_type via rate. The purpose of those is to verify that the key being inserted already exists in the parent (eg employee) table. -- Adrian Klaver adrian.kla...@aklaver.com

Re: "Locking rows"

2019-08-12 Thread Adrian Klaver
" way to handle this? Depends on who is doing the database record changes. In other words are there defined roles: https://www.postgresql.org/docs/11/sql-createrole.html for the object(table) and the entity working with the table? -- Adrian Klaver adrian.kla...@aklaver.com

Re: "Locking rows"

2019-08-12 Thread Adrian Klaver
On 8/12/19 1:07 PM, stan wrote: On Mon, Aug 12, 2019 at 12:14:25PM -0700, Adrian Klaver wrote: On 8/12/19 10:51 AM, stan wrote: I have a customer requirement/desire. The system is (among other things) essentially a employee time sheet. The manager wants for an employee to not be able to modify

Re: Bulk Inserts

2019-08-13 Thread Adrian Klaver
re than double the time taken to insert the tuples into tab2 without serial id column. Best, -SB -- Adrian Klaver adrian.kla...@aklaver.com

Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg

2019-08-13 Thread Adrian Klaver
have a char(n) column that could be enlarged before the migration. <https://support.oracle.com/knowledge/Siebel/476591_1.html> Hope this helps. And please report the version of ora2pg when asking for help. Luca -- Adrian Klaver adrian.kla...@aklaver.com

Re: GIST/GIN index not used with Row Level Security

2019-08-13 Thread Adrian Klaver
ad of like, using full text search and larger data sets (e.g. 100k rows). This is on PostgreSQL v11.1 on Windows 10. -- *Derek* +1 (415) 754-0519 |derek.h...@gmail.com <mailto:derek.h...@gmail.com> | Skype: derek.hans -- Adrian Klaver adrian.kla...@aklaver.com

Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg

2019-08-14 Thread Adrian Klaver
client encoding: Oracle NLS_LANG AMERICAN_AMERICA.WE8MSWIN1252 Oracle NLS_NCHAR WE8MSWIN1252 Oracle NLS_TIMESTAMP_FORMAT -MM-DD HH24:MI:SS.FF6 Oracle NLS_DATE_FORMAT -MM-DD HH24:MI:SS PostgreSQL CLIENT_ENCODING WIN1252 bash-4.2$ thanks -- Adrian Kl

Re: Converting Access .mdb to postgres

2019-08-14 Thread Adrian Klaver
ng consistent. Among the tables are many lookup tables. I don't know whether to leave them as tables or apply a different structure to them. Advice, suggestions, and recommendations are all welcome. TIA, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: Converting Access .mdb to postgres

2019-08-14 Thread Adrian Klaver
On 8/14/19 10:45 AM, Rich Shepard wrote: On Wed, 14 Aug 2019, Adrian Klaver wrote: So you have the tables in Postgres, correct? Adrian, Not yet. I have the schema extracted using mdb-schema. I did something similar with the USDA Nutrient database(with notion of making it a test dataset

Re: Converting Access .mdb to postgres

2019-08-14 Thread Adrian Klaver
On 8/14/19 11:11 AM, Rich Shepard wrote: On Wed, 14 Aug 2019, Adrian Klaver wrote: Have you looked at: https://www.streamnet.org/wp-content/uploads/2018/06/StreamNetExchangeStandard2018-1.doc Thanks, Adrian. This looks like it has all the information I need. Under which menu did you find

Re: slow queries on system tables

2019-08-15 Thread Adrian Klaver
://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Variable constants ?

2019-08-15 Thread Adrian Klaver
can be updated/deleted(though you could revoke that also). -- Adrian Klaver adrian.kla...@aklaver.com

Re: Missing Trigger after pgdump install

2019-08-16 Thread Adrian Klaver
can think of but we're still missing the trigger every day. Thanks for your help! Sue -- Adrian Klaver adrian.kla...@aklaver.com

Re: Missing Trigger after pgdump install

2019-08-16 Thread Adrian Klaver
...@brookhurstdata.com Mobile: 314-486-3261 On 2019-08-16 13:37, Adrian Klaver wrote: On 8/16/19 11:27 AM, Susan Hurst wrote: What scenarios can cause a single trigger to be omitted when populating an empty database from a pgdump file? We have nightly backups of our production database that we loa

Re: Missing Trigger after pgdump install

2019-08-16 Thread Adrian Klaver
to do with this: https://www.postgresql.org/docs/9.5/release-9-5-12.html "Avoid use of insecure search_path settings in pg_dump and other client programs (Noah Misch, Tom Lane)" Are you using the 9.5.0 or 9.5.14 version of pg_dump to dump from the production server? -- Adri

Re: Missing Trigger after pgdump install

2019-08-16 Thread Adrian Klaver
o say it has something to do with this: https://www.postgresql.org/docs/9.5/release-9-5-12.html "Avoid use of insecure search_path settings in pg_dump and other client programs (Noah Misch, Tom Lane)" Are you using the 9.5.0 or 9.5.14 version of pg_dump to dump from the production serve

Re: Transaction state on connection Idle/Open/Failed

2019-08-17 Thread Adrian Klaver
https://jdbc.postgresql.org/development/privateapi/org/postgresql/core/ProtocolConnection.html Thanks, David -- Adrian Klaver adrian.kla...@aklaver.com

<    3   4   5   6   7   8   9   10   11   12   >