Re: Need support on tuning at the time of index creation

On 2020-01-27 11:10:36 +, Sandip Pradhan wrote: > One of our ericsson product used backend db as postgresql 9. We are facing > following performance issues where we need some support from your side. > We are having 10 tables and we are inserting around 150 million to 250 million > records on ea

Re: How to transfer databases form one server to other

Am 27.01.20 um 21:47 schrieb Adrian Klaver: On 1/26/20 10:56 PM, Andrus wrote: Hi! 3. Manually edit role definitions to delete role postgres since it exists in new server. No need, it will throw a harmless error message and continue on. By my knowledge, pgAdmin executes script in single tr

Re: temporary data after diskspace error

Willy-Bas Loos writes: > Will there be a lot of downtime to delete those 90GB of temp files? > Will postgres just delete those files without processing them or should I > brace for some downtime? It's just a directory scan and an unlink() for each file that has the right filename pattern to be a

Re: How to transfer databases form one server to other

On 1/26/20 10:56 PM, Andrus wrote: Hi! 3. Manually edit role definitions to delete role postgres since it exists in new server. No need, it will throw a harmless error message and continue on. By my knowledge, pgAdmin executes script in single transaction and rolls it back on error. Should

Re: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

On 1/27/20 8:37 AM, Tanja Savic wrote: Hi, I reset tcpip stack but didn't work, same error and behavior. Next ideas: 1) Check the Windows system logs for any clues. 2) Did you recently upgrade pgAdmin? 3) How did you install pgAdmin? Tanja -Original Message- From: Adrian Klaver

Re: temporary data after diskspace error

Ok, thanks everyone! Will there be a lot of downtime to delete those 90GB of temp files? Will postgres just delete those files without processing them or should I brace for some downtime? Op ma 27 jan. 2020 17:15 schreef Tom Lane : > Willy-Bas Loos writes: > > And also: How can i make postgres

Re: temporary data after diskspace error

In terms of preventing this happening again, you might consider setting some reasonable temp_file_limit as default. Alternatively or additionally, you can set up another volume and direct temp files to use that to avoid the server crashing if excessive temp files are used in a moment's time. Then o

RE: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

Hi, I reset tcpip stack but didn't work, same error and behavior. Tanja -Original Message- From: Adrian Klaver Sent: Friday, January 24, 2020 5:30 PM To: Tanja Savic ; pgsql-general@lists.postgresql.org Subject: Re: PostgresSQL 10 on remote server - Socket is not connected (0x27

Re: temporary data after diskspace error

Willy-Bas Loos writes: > And also: How can i make postgres clean up the files? > Can it be done without restarting the cluster? > Will restarting it help? A restart will clean out temp files. I don't think there's any terribly safe way to do it without that. You could manually remove such files

Re: temporary data after diskspace error

On 1/27/20 10:05 AM, Willy-Bas Loos wrote: Hi, We have a server with postgresql 9.4.12 on ubuntu. There has been a sudden rise in the amount of disk space used by postgresql, causing a diskspace error: 2020-01-22 17:24:37 CET db: ip: us: PANIC:  could not write to file "pg_xlog/xlogtemp.2334

temporary data after diskspace error

Hi, We have a server with postgresql 9.4.12 on ubuntu. There has been a sudden rise in the amount of disk space used by postgresql, causing a diskspace error: 2020-01-22 17:24:37 CET db: ip: us: PANIC: could not write to file "pg_xlog/xlogtemp.23346": No space left on device 2020-01-22 17:24:37

Re: How to transfer databases form one server to other

On 27/01/2020 12:40, Andrus wrote: > Hi! > >>> Postgres version 12 pg_dump probably cannot installed in old server >>> (Debian Squeeze 9). > >> I have it installed on my Debian 9 laptop, from the PostgreSQL apt repo: > >>  https://apt.postgresql.org > > Oled server uses Debian Sqeeze whose vers

Re: Need support on tuning at the time of index creation

On Mon, Jan 27, 2020 at 5:27 AM Ron wrote: > On 1/27/20 5:10 AM, Sandip Pradhan wrote: > > Dear Sir/Madam, > > > > One of our ericsson product used backend db as postgresql 9. We are > facing > > following performance issues where we need some support from your side. > > We are having 10 tables a

Re: How to transfer databases form one server to other

Hi! Postgres version 12 pg_dump probably cannot installed in old server (Debian Squeeze 9). I have it installed on my Debian 9 laptop, from the PostgreSQL apt repo: https://apt.postgresql.org Oled server uses Debian Sqeeze whose version is 6. I mistakenly typed Debian Squeeze 9, I'm sor

Re: Need support on tuning at the time of index creation

On 1/27/20 5:10 AM, Sandip Pradhan wrote: Dear Sir/Madam, One of our ericsson product used backend db as postgresql 9. We are facing following performance issues where we need some support from your side. We are having 10 tables and we are inserting around 150 million to 250 million records on

Need support on tuning at the time of index creation

Dear Sir/Madam, One of our ericsson product used backend db as postgresql 9. We are facing following performance issues where we need some support from your side. We are having 10 tables and we are inserting around 150 million to 250 million records on each of those tables. After that we need to

Re: How to transfer databases form one server to other

On 1/26/20 10:44 PM, Andreas Joseph Krogh wrote: På mandag 27. januar 2020 kl. 03:26:59, skrev Ron >: [..] I ran *uncompressed* pg_dump on multiple TB+ sized databases from v8.4 servers across the LAN using 9.6 binaries on the remote server.  It wa

Re: How to transfer databases form one server to other

On 26/01/2020 22:47, Andrus wrote: > Hi! > >> Before you do any of this I would check the Release Notes for the >> first release of each major release. Prior to version 10 that would be >> X.X.x where X is a major release. For 10+ that is X.x.  I would also >> test the upgrade before doing it on y

Re: How to transfer databases form one server to other

Hi! 3. Manually edit role definitions to delete role postgres since it exists in new server. No need, it will throw a harmless error message and continue on. By my knowledge, pgAdmin executes script in single transaction and rolls it back on error. Should psql used or is there some option in

Re: How to transfer databases form one server to other

Hi! Before you do any of this I would check the Release Notes for the first release of each major release. Prior to version 10 that would be X.X.x where X is a major release. For 10+ that is X.x. I would also test the upgrade before doing it on your production setup. I want to create test t