Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iuzFX-0004mC-9F for pgsql-admin@arkaria.postgresql.org; Fri, 24 Jan 2020 13:43:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iuzFT-0008P3-Di for pgsql-admin@arkaria.postgresql.org; Fri, 24 Jan 2020 13:43:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iuzFT-0008Ow-02 for pgsql-admin@lists.postgresql.org; Fri, 24 Jan 2020 13:43:47 +0000 Received: from mail-wm1-x32f.google.com ([2a00:1450:4864:20::32f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iuzFN-0005cv-Oh for pgsql-admin@lists.postgresql.org; Fri, 24 Jan 2020 13:43:46 +0000 Received: by mail-wm1-x32f.google.com with SMTP id c84so874139wme.4 for ; Fri, 24 Jan 2020 05:43:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=7OHEl/0lLkYurG+TkzMXfisa18QkmXbUlJzQxh1DKOM=; b=g0PGSawr39Z7sIuvUXzwPy3pGgqLXGvlklPUEmFtoFAsZejwndvCwwZ0MAWFRWdaEU +SQt/hKya3STDLqMw6d06A46xouW3QmOcw2558hS1JIIMYpF9JDVnCmYSmAJr0yvYFiG H5pu3443uWULAH+lmWNRPC+OjF1UpfUAdTaSQt4aiOS5DFPgoP4n6gCBo41hvkivYlw8 bAb92G9J5tfqD1Bx60OFJGxLPOnetQ3K1MRuE6mU5RVZAd+jQ3OJy6JM0g4J52ptGbWW cO+PUQJ0gluj7/LcSxdK7ZG79oRChgXirjyTJ+QHBsSB9CY4H6uj5VUgdUNIIrYl/A8F Evjw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=7OHEl/0lLkYurG+TkzMXfisa18QkmXbUlJzQxh1DKOM=; b=qbWjKCylWEXSHV0AtA/3XkhNBSnnMzU7eVy+vY1uaPwCW2+/M3hW5KbEerFxVl6+VQ rmPNMFA7H7PB/T0KP4KKyOXCqQI3k+sXELPygrKc73jIlsf4dFl5LfQ38V+aLDXXque/ fJw7A5YuymU9Qb2MzKLqU7yGyEu2RTfeZ0kLfAVq/57jZ2geDDT439Cg+6Vmb1rhwtLU FzGvkhRLaBom/eGNiPj8oKKle5bOHxUAuqrzzrIBKugiwmYcTXAtOMvsz80CMav0zO50 Vrqm5Cy/q7oITITFPiAvgrCjcv+iBXQlnMK1fNWEDDKV185/+1FrRI7THDUskV3VUpL3 0BIw== X-Gm-Message-State: APjAAAX7jNNe3XtaDpvlbV5cwPROdh2H2nN9UiSWR8IjyTEQEQ7JwVBe 2Wen+GELdDo9Q8z/yNUliFl86A== X-Google-Smtp-Source: APXvYqyUSlrrXQPHfQLVYY0kDHA97Zt53+y3pcLIqPn3ylf6tFGUlYljH2SMFyA8SIg6ZxOhWggZhw== X-Received: by 2002:a1c:a445:: with SMTP id n66mr3567825wme.151.1579873419515; Fri, 24 Jan 2020 05:43:39 -0800 (PST) Received: from localhost.localdomain (217-149-170-234.nat.highway.telekom.at. [217.149.170.234]) by smtp.gmail.com with ESMTPSA id a132sm6884985wme.3.2020.01.24.05.43.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 24 Jan 2020 05:43:39 -0800 (PST) Message-ID: Subject: Re: Need assistance in Oracle11g to Postgres migration From: Laurenz Albe To: varinder gupta , pgsql-admin@lists.postgresql.org Date: Fri, 24 Jan 2020 14:43:38 +0100 In-Reply-To: <2033117469.13483913.1579870903308@mail.yahoo.com> References: <2033117469.13483913.1579870903308.ref@mail.yahoo.com> <2033117469.13483913.1579870903308@mail.yahoo.com> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.32.5 (3.32.5-1.fc30) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, 2020-01-24 at 13:01 +0000, varinder gupta wrote: > We are planning to migrate Oracle 11g (200 GB) to Postgres. > What should be the virtual machine configuration that will host the Postgres? > - the number of cores, RAM and Disc space for the virtual machine. Something similar to your Oracle installation, perhaps. The question is way too general for a good answer. Yours, Laurenz Albe